FormatConditionAboveBelow
Constants which specify the manner in which cell values are compared when evaluating a [[AverageConditionalFormat]].
Enumeration Members
Section titled "Enumeration Members"AboveAverage
Section titled "AboveAverage"The cell value must be above the average for the associated range in order to meet the associated condition.
AboveAverage = 0AboveStandardDeviation
Section titled "AboveStandardDeviation"The cell value must be above the standard deviation for the associated range in order to meet the associated condition.
AboveStandardDeviation = 4BelowAverage
Section titled "BelowAverage"The cell value must be below the average for the associated range in order to meet the associated condition.
BelowAverage = 1BelowStandardDeviation
Section titled "BelowStandardDeviation"The cell value must be below the standard deviation for the associated range in order to meet the associated condition.
BelowStandardDeviation = 5EqualAboveAverage
Section titled "EqualAboveAverage"The cell value must be equal to or above the average for the associated range in order to meet the associated condition.
EqualAboveAverage = 2EqualBelowAverage
Section titled "EqualBelowAverage"The cell value must be equal to or below the average for the associated range in order to meet the associated condition.
EqualBelowAverage = 3