Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |