MinStandardDeviationLevel Constant

Specifies the default standard deviation multiplier.

Declaration

const MinStandardDeviationLevel = 1;

Remarks

The conditional formatting controller uses the standard deviation of cell values within the affected range(s) multiplied by the StandardDeviationLevel property value only if the ComparisonOperator property is set to abacoAboveAverageOnStandardDeviation or abacoBelowAverageOnStandardDeviation. By default, in these modes the “Above or Below Average” conditional formatting rule applies custom formatting only to those cells whose values are above/below average plus/minus the standard deviation, since the deviation multiplier is 1:

The StandardDeviationLevel property value is clamped within the range between the MinStandardDeviationLevel and MaxStandardDeviationLevel constant values, inclusive.