XlFormatConditionType Enumeration
Specifies whether the conditional format is based on a cell value or an expression.
Version Information
Version Added: Excel 2007
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 |