XlCondFmtAverageCondition Enum

Lists the types of format operators used in the “Above or Below Average…” conditional formatting rule.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlCondFmtAverageCondition

VB.NET

Public Enum XlCondFmtAverageCondition

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 XlCondFmtAverageCondition values:

• XlCondFmtRuleAboveAverage.Condition

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlCondFmtAverageCondition 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#L55

XlCondFmtRuleAboveAverage rule = new XlCondFmtRuleAboveAverage();
rule.Condition = XlCondFmtAverageCondition.Above;
// 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#L58

Dim rule As New XlCondFmtRuleAboveAverage()
rule.Condition = XlCondFmtAverageCondition.Above
' Specify formatting settings to be applied to cells if the condition is true.