XlFormatConditionOperator Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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: