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