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. |