MaxStandardDeviationLevel Constant

Specifies the maximum standard deviation multiplier.

Declaration

const MaxStandardDeviationLevel = 3;

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.

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