Skip to main content

XlFormatConditionType enumeration

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>