XlFormatConditionType enumeration (Excel)

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.