XlFormatConditionType Enumeration
Specifies whether the conditional format is based on a cell value or an expression.
Version Information
Version Added: Excel
| Name | Value | Description |
|---|---|---|
| xlAboveAverageCondition | 12 | Above average condition |
| xlBlanksCondition | 10 | Blanks condition |
| xlCellValue | 1 | Cell value |
| xlColorScale | 3 | Color scale |
| xlCompareColumns | 18 | Compare columns |
| 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 |