Share via

2.4.6 conditionalFormattings

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

A conditionalFormattings element is a CT_ConditionalFormattings type element, as specified in section 2.6.1, that specifies conditional formatting information for the worksheet. See section 2.2.4.12 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2016].

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this element.

 <xsd:element name="conditionalFormattings" type="CT_ConditionalFormattings"/>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).