XlCondFmtSpecificTextType Enum

List values specifying the type of the conditional format operator in a conditional formatting rule.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlCondFmtSpecificTextType

VB.NET

Public Enum XlCondFmtSpecificTextType

Members

Name	Description
Contains	Format cells that contain the specified text string.
NotContains	Format cells that do not contain the specified text string.
BeginsWith	Format cells that begin with the specified text string.
EndsWith	Format cell that end with the specified text string.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlCondFmtSpecificTextType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.cs#L397

// Create the rule to highlight cells that contain the given text.
XlCondFmtRuleSpecificText rule = new XlCondFmtRuleSpecificText(XlCondFmtSpecificTextType.Contains, "worldwide");
// Specify formatting settings to be applied to cells if the condition is true.

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.vb#L396

' Create the rule to highlight cells that contain the given text.
Dim rule As New XlCondFmtRuleSpecificText(XlCondFmtSpecificTextType.Contains, "worldwide")
' Specify formatting settings to be applied to cells if the condition is true.