Specifies whether the conditional format is based on a cell value or an expression.
Name | Value | Description |
---|---|---|
xlAboveAverageCondition | 12 | Above average condition |
xlBlanksCondition | 10 | Blanks condition |
xlCellValue | 1 | Cell value |
xlColorScale | 3 | Color scale |
xlDataBar | 4 | DataBar |
xlErrorsCondition | 16 | Errors condition |
xlExpression | 2 | Expression |
xlIconSet | 6 | Icon set |
xlNoBlanksCondition | 13 | No blanks condition |
xlNoErrorsCondition | 17 | No errors condition |
xlTextString | 9 | Text string |
xlTimePeriod | 11 | Time period |
xlTop10 | 5 | Top 10 values |
xlUniqueValues | 8 | Unique values |