TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverage.StandardDeviationLevel Property

Specifies the standard deviation multiplier for the “Above or Below Average” conditional formatting rule.

Declaration

delphi

property StandardDeviationLevel: Integer read; write; default MinStandardDeviationLevel;

Property Value

Type	Default
Integer	MinStandardDeviationLevel

Remarks

Use this property to set the value multiplied by the standard deviation level of cell values within the cell range(s) affected by the rule. The StandardDeviationLevel property value is clamped within the range between the MinStandardDeviationLevel and MaxStandardDeviationLevel constant values, inclusive. The higher the multiplier, the fewer cells are formatted by the “Above or Below Average” conditional formatting rule:

If the ComparisonOperator property is set to abacoAboveAverageOnStandardDeviation or abacoBelowAverageOnStandardDeviation, the conditional formatting controller applies the rule’s formatting to those cells within the affected area(s) whose values are above or below the average plus or minus the product of the standard deviation and the StandardDeviationLevel property value, respectively. The controller ignores the StandardDeviationLevel property value in the case of all other "Above or Below Average" conditional formatting rule calculation modes.

The default StandardDeviationLevel property value is MinStandardDeviationLevel.