Contains the qualifier of a condition in conditional text formatting and data validation.
Contained In
Remarks
For conditional formatting, this element can contain one of the following string constants:
| Between | NotBetween |
| Equal | NotEqual |
| Greater | Less |
| GreaterOrEqual | LessOrEqual |
When a Qualifier element is specified, the value of a cell in the specified range is compared to the values or results of formulas specified by the Value1 and Value2 elements. If the Qualifier element is not specified, a formula specified by the Value1 element is used as a condition, and the formula must return a Boolean value. In both cases, the formatting is applied only if the condition is true.
For data validation, this element can contain one of the string constants in the previous list or N/A. The default value is Between.
See the examples in the ConditionalFormatting and DataValidation element topics.