XlFormatConditionType XlFormatConditionType XlFormatConditionType Enum

Definition

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

public enum class XlFormatConditionType
public enum XlFormatConditionType
Public Enum XlFormatConditionType
Inheritance
XlFormatConditionTypeXlFormatConditionTypeXlFormatConditionType

Fields

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

Databar

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