Expand Minimize

XlFormatConditionOperator Enumeration (Excel)

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

Name

Value

Description

xlBetween

1

Between. Can be used only if two formulas are provided.

xlEqual

3

Equal.

xlGreater

5

Greater than.

xlGreaterEqual

7

Greater than or equal to.

xlLess

6

Less than.

xlLessEqual

8

Less than or equal to.

xlNotBetween

2

Not between. Can be used only if two formulas are provided.

xlNotEqual

4

Not equal.

Show:
© 2014 Microsoft