TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverage.ComparisonOperator Property

Specifies the cell value comparison operator for calculating the “Above or Below Average” rule’s formatting condition.

Declaration

property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperator read; write; default abacoAboveAverage;

Property Value

Type	Default
TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperator	abacoAboveAverage

Remarks

Use this property to switch the “Above or Below Average” conditional formatting rule between available modes that determine to which cells within the affected cell range(s) the custom cell style is applied. Note that certain rule condition calculation modes also use the specified standard deviation level. Refer to the TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperator type description for detailed information on all “Above or Below Average” rule’s formatting condition calculation modes.

The default ComparisonOperator property value is abacoAboveAverage.