ConditionalFormattingAverageCondition Enum

Lists values that specify the type of the conditional format operator in an "above or below average" conditional formatting rule.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public enum ConditionalFormattingAverageCondition

VB.NET

Public Enum ConditionalFormattingAverageCondition

Members

Name	Description
Above	Formats cells whose values are above the average value in a range of cells.
AboveOrEqual	Formats cells whose values are above or equal to the average value in a range of cells.
Below	Formats cells whose values are below the average value in a range of cells.
BelowOrEqual	Formats cells whose values are below or equal to the average value in a range of cells.

Related API Members

The following properties accept/return ConditionalFormattingAverageCondition values:

• AverageConditionalFormatting.Condition

Remarks

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

Related GitHub Examples

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

// Create the rule highlighting values that are above the average in cells C2 through C15.
AverageConditionalFormatting cfRule1 = conditionalFormattings.AddAverageConditionalFormatting(worksheet.Range["$C$2:$C$15"], ConditionalFormattingAverageCondition.AboveOrEqual);
// 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#L40

// Create the rule highlighting values that are above the average in cells C2 through C15.
AverageConditionalFormatting cfRule1 = conditionalFormattings.AddAverageConditionalFormatting(worksheet["$C$2:$C$15"], ConditionalFormattingAverageCondition.AboveOrEqual);
// 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#L38

// Create the rule highlighting values that are above the average in cells C2 through C15.
AverageConditionalFormatting cfRule1 = conditionalFormattings.AddAverageConditionalFormatting(worksheet.Range["$C$2:$C$15"], ConditionalFormattingAverageCondition.AboveOrEqual);
// 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#L35

' Create the rule highlighting values that are above the average in cells C2 through C15.
Dim cfRule1 As AverageConditionalFormatting = conditionalFormattings.AddAverageConditionalFormatting(worksheet.Range("$C$2:$C$15"), ConditionalFormattingAverageCondition.AboveOrEqual)
' 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#L36

' Create the rule highlighting values that are above the average in cells C2 through C15.
Dim cfRule1 As AverageConditionalFormatting = conditionalFormattings.AddAverageConditionalFormatting(worksheet("$C$2:$C$15"), ConditionalFormattingAverageCondition.AboveOrEqual)
' 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#L37

' Create the rule highlighting values that are above the average in cells C2 through C15.
Dim cfRule1 As AverageConditionalFormatting = conditionalFormattings.AddAverageConditionalFormatting(worksheet.Range("$C$2:$C$15"), ConditionalFormattingAverageCondition.AboveOrEqual)
' Specify formatting options to be applied to cells if the condition is true.