XlFormatConditionType Enumeration

Specifies whether the conditional format is based on a cell value or an expression.

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

Show: