This documentation is archived and is not being maintained.

# XlFormatConditionOperator Enumeration

Office 2007
Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
NameValueDescription
xlBetween1Between. Can be used only if two formulas are provided.
xlEqual3Equal.
xlGreater5Greater than.
xlGreaterEqual7Greater than or equal to.
xlLess6Less than.
xlLessEqual8Less than or equal to.
xlNotBetween2Not between. Can be used only if two formulas are provided.
xlNotEqual4Not equal.

Show: