Conditional Formatting

xlConditionValueTypes	Specifies the types of condition values that can be used.
xlFormatConditionOperator	Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
xlFormatConditionType	Specifies whether the conditional format is based on a cell value or an expression.

xlConditionValueTypes Specifies the types of condition values that can be used.
xlFormatConditionOperator Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
xlFormatConditionType Specifies whether the conditional format is based on a cell value or an expression.

xlConditionValueTypes

Specifies the types of condition values that can be used.

xlConditionValueAutomaticMax	(Added in 2010) (7)
xlConditionValueAutomaticMin	(Added in 2010) (6)
xlConditionValueFormula	Formula is used (4)
xlConditionValueHighestValue	Highest value from the list of values (2)
xlConditionValueLowestValue	Lowest value from the list of values (1)
xlConditionValueNone	No conditional value (-1)
xlConditionValueNumber	Number is used (0)
xlConditionValuePercent	Percentage is used (3)
xlConditionValuePercentile	Percentile is used (5)

xlConditionValueAutomaticMax

(Added in 2010) (7)

xlConditionValueAutomaticMin

(Added in 2010) (6)

xlConditionValueFormula

Formula is used (4)

xlConditionValueHighestValue

Highest value from the list of values (2)

xlConditionValueLowestValue

Lowest value from the list of values (1)

xlConditionValueNone

No conditional value (-1)

xlConditionValueNumber

Number is used (0)

xlConditionValuePercent

Percentage is used (3)

xlConditionValuePercentile

Percentile is used (5)

REMARKS

* Added in 2007.

xlFormatConditionOperator

Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.

xlBetween	Between Can be used only if two formulas are provided (1)
xlEqual	Equal (3)
xlGreater	Greater than (5)
xlGreaterEqual	Greater than or equal to (7)
xlLess	Less than (6)
xlLessEqual	Less than or equal to (8)
xlNotBetween	Not between Can be used only if two formulas are provided (2)
xlNotEqual	Not equal (4)

xlBetween

Between
Can be used only if two formulas are provided (1)

xlEqual

Equal (3)

xlGreater

Greater than (5)

xlGreaterEqual

Greater than or equal to (7)

xlLess

Less than (6)

xlLessEqual

Less than or equal to (8)

xlNotBetween

Not between
Can be used only if two formulas are provided (2)

xlNotEqual

Not equal (4)

xlFormatConditionType

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

xlAboveAverageCondition	(Added in 2007) Above average condition (12)
xlBlanksCondition	(Added in 2007) Blanks condition (10)
xlCellValue	Cell value (1)
xlColorScale	(Added in 2007) Color scale (3)
xlDatabar	(Added in 2007) Databar (4)
xlErrorsCondition	(Added in 2007) Errors condition (16)
xlExpression	Expression (2)
xlIconSets	(Added in 2007) Icon set (6)
xlNoBlanksCondition	(Added in 2007) No blanks condition (13)
xlNoErrorsCondition	(Added in 2007) No errors condition (17)
xlTextString	(Added in 2007) Text string (9)
xlTimePeriod	(Added in 2007) Time period (11)
xlTop10	(Added in 2007) Top 10 values (5)
xlUniqueValues	(Added in 2007) Unique values (8)

xlAboveAverageCondition

(Added in 2007) Above average condition (12)

xlBlanksCondition

(Added in 2007) Blanks condition (10)

xlCellValue

Cell value (1)

xlColorScale

(Added in 2007) Color scale (3)

xlDatabar

(Added in 2007) Databar (4)

xlErrorsCondition

(Added in 2007) Errors condition (16)

xlExpression

Expression (2)

xlIconSets

(Added in 2007) Icon set (6)

xlNoBlanksCondition

(Added in 2007) No blanks condition (13)

xlNoErrorsCondition

(Added in 2007) No errors condition (17)

xlTextString

(Added in 2007) Text string (9)

xlTimePeriod

(Added in 2007) Time period (11)

xlTop10

(Added in 2007) Top 10 values (5)

xlUniqueValues

(Added in 2007) Unique values (8)