ConditionalFormattingExpressionCondition Enum

Lists values that specify the type of the relational operator in a conditional formatting rule.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

C#

public enum ConditionalFormattingExpressionCondition

VB.NET

Public Enum ConditionalFormattingExpressionCondition

Members

Name	Description
EqualTo	Formats cells whose values are equal to a specified value.
UnequalTo	Formats cells whose values are not equal to a specified value.
LessThan	Formats cells whose values are less than a specified value.
LessThanOrEqual	Formats cells whose values are less than or equal to a specified value.
GreaterThan	Formats cells whose values are greater than a specified value.
GreaterThanOrEqual	Formats cells whose values are greater than or equal to a specified value.

Related API Members

The following properties accept/return ConditionalFormattingExpressionCondition values:

• ExpressionConditionalFormatting.Condition

Remarks

The values listed by this enumeration are used by the ExpressionConditionalFormatting.Condition property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ConditionalFormattingExpressionCondition 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#

how-to-apply-conditional-formatting-to-a-range-of-cells-wpf-spreadsheet-e4968/CS/ConditionalFormatting_WPF_Examples/SpreadsheetActions/ConditionalFormatting.cs#L207

ExpressionConditionalFormatting cfRule =
worksheet.ConditionalFormattings.AddExpressionConditionalFormatting(worksheet.Range["$F$2:$F$15"], ConditionalFormattingExpressionCondition.GreaterThan, "=AVERAGE($F$2:$F$15)");
// Specify formatting options to be applied to cells if the condition is true.

how-to-apply-conditional-formatting-to-a-range-of-cells-e4959/CS/ConditionalFormatting_Example/SpreadsheetActions/ConditionalFormatting.cs#L210

ExpressionConditionalFormatting cfRule =
worksheet.ConditionalFormattings.AddExpressionConditionalFormatting(worksheet["$F$2:$F$15"], ConditionalFormattingExpressionCondition.GreaterThan, "=AVERAGE($F$2:$F$15)");
// Specify formatting options to be applied to cells if the condition is true.

how-to-apply-conditional-formatting-to-a-range-of-cells-e4929/CS/SpreadsheetControl/SpreadsheetActions/ConditionalFormatting.cs#L208

ExpressionConditionalFormatting cfRule =
worksheet.ConditionalFormattings.AddExpressionConditionalFormatting(worksheet.Range["$F$2:$F$15"], ConditionalFormattingExpressionCondition.GreaterThan, "=AVERAGE($F$2:$F$15)");
// Specify formatting options to be applied to cells if the condition is true.

VB.NET

how-to-apply-conditional-formatting-to-a-range-of-cells-wpf-spreadsheet-e4968/VB/ConditionalFormatting_WPF_Examples/SpreadsheetActions/ConditionalFormatting.vb#L179

' Create the rule to identify values that are above the average in cells F2 through F15.
Dim cfRule As ExpressionConditionalFormatting = worksheet.ConditionalFormattings.AddExpressionConditionalFormatting(worksheet.Range("$F$2:$F$15"), ConditionalFormattingExpressionCondition.GreaterThan, "=AVERAGE($F$2:$F$15)")
' Specify formatting options to be applied to cells if the condition is true.

how-to-apply-conditional-formatting-to-a-range-of-cells-e4959/VB/ConditionalFormatting_Example/SpreadsheetActions/ConditionalFormatting.vb#L180

' Create the rule to identify values that are above the average in cells F2 through F15.
Dim cfRule As ExpressionConditionalFormatting = worksheet.ConditionalFormattings.AddExpressionConditionalFormatting(worksheet("$F$2:$F$15"), ConditionalFormattingExpressionCondition.GreaterThan, "=AVERAGE($F$2:$F$15)")
' Specify formatting options to be applied to cells if the condition is true.

how-to-apply-conditional-formatting-to-a-range-of-cells-e4929/VB/SpreadsheetControl/SpreadsheetActions/ConditionalFormatting.vb#L181

' Create the rule to identify values that are above the average in cells F2 through F15.
Dim cfRule As ExpressionConditionalFormatting = worksheet.ConditionalFormattings.AddExpressionConditionalFormatting(worksheet.Range("$F$2:$F$15"), ConditionalFormattingExpressionCondition.GreaterThan, "=AVERAGE($F$2:$F$15)")
' Specify formatting options to be applied to cells if the condition is true.