Share via


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