XlFormatConditionType XlFormatConditionType XlFormatConditionType Enum


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

public enum class XlFormatConditionType
public enum XlFormatConditionType
Public Enum XlFormatConditionType


xlAboveAverageCondition xlAboveAverageCondition xlAboveAverageCondition 12

Above average condition

xlBlanksCondition xlBlanksCondition xlBlanksCondition 10

Blanks condition

xlCellValue xlCellValue xlCellValue 1

The conditional format is based on a cell value.

xlColorScale xlColorScale xlColorScale 3

Color scale

xlDatabar xlDatabar xlDatabar 4


xlErrorsCondition xlErrorsCondition xlErrorsCondition 16

Errors condition

xlExpression xlExpression xlExpression 2

The conditional format is based on an expression.

xlIconSets xlIconSets xlIconSets 6

Icon sets

xlNoBlanksCondition xlNoBlanksCondition xlNoBlanksCondition 13

No blanks condition

xlNoErrorsCondition xlNoErrorsCondition xlNoErrorsCondition 17

No errors condition

xlTextString xlTextString xlTextString 9

Text string

xlTimePeriod xlTimePeriod xlTimePeriod 11

Time period

xlTop10 xlTop10 xlTop10 5

Top 10 values

xlUniqueValues xlUniqueValues xlUniqueValues 8

Unique values

Applies to