Contains a condition and the formatting that is applied to a cell when the condition is true.
| Attribute | Description |
| Style | A text string containing subattributes that specify the font weight, style, and effects that are applied when the qualifying condition is true. |
Contained In
Subelements
Format, Qualifier, Value1, Value2
Remarks
One to three Condition subelements must be included in a ConditionalFormatting element.
When a Qualifier subelement is specified, the value of a cell in the specified range is compared to the values or results of the formulas specified in the Value1 and Value2 elements. When a Qualifier subelement is not specified, the formula specified in the Value1 element is used as the condition, and the formula must return a Boolean value. In both cases, the formatting is applied only if the condition is True.
You can specify a conditional formatting style in the Style attribute of the Condition element or in the Format subelement. However, you cannot specify the Style attribute and the Format subelement in the same Condition element.
See the example in the ConditionalFormatting element topic.