ig.excel.FormatConditionAboveBelow
Dependencies
-
aboveAverage
- Type:
- ig.excel.FormatConditionAboveBelow
- Default:
- 0
The cell value must be above the average for the associated range in order to meet the associated condition.
-
aboveStandardDeviation
- Type:
- ig.excel.FormatConditionAboveBelow
- Default:
- 4
The cell value must be above the standard deviation for the associated range in order to meet the associated condition.
-
belowAverage
- Type:
- ig.excel.FormatConditionAboveBelow
- Default:
- 1
The cell value must be below the average for the associated range in order to meet the associated condition.
-
belowStandardDeviation
- Type:
- ig.excel.FormatConditionAboveBelow
- Default:
- 5
The cell value must be below the standard deviation for the associated range in order to meet the associated condition.
-
equalAboveAverage
- Type:
- ig.excel.FormatConditionAboveBelow
- Default:
- 2
The cell value must be equal to or above the average for the associated range in order to meet the associated condition.
-
equalBelowAverage
- Type:
- ig.excel.FormatConditionAboveBelow
- Default:
- 3
The cell value must be equal to or below the average for the associated range in order to meet the associated condition.