XlFormatConditionOperator Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
public enum class XlFormatConditionOperatorpublic enum XlFormatConditionOperatorPublic Enum XlFormatConditionOperator- Inheritance
-
XlFormatConditionOperator
Fields
| Name | Value | Description |
|---|---|---|
| xlBetween | 1 | Between. Can only be used if two formulas are provided. |
| xlNotBetween | 2 | Not between. Can only be used if two formulas are provided. |
| xlEqual | 3 | Equal. |
| xlNotEqual | 4 | Not equal. |
| xlGreater | 5 | Greater than. |
| xlLess | 6 | Less than. |
| xlGreaterEqual | 7 | Greater than or equal to. |
| xlLessEqual | 8 | Less than or equal to. |