ConditionalFormattings class
Defines the ConditionalFormattings Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:conditionalFormattings.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.ConditionalFormattings
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
2.4.6 conditionalFormattings
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.11 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].
The following W3C XML Schema ([XMLSCHEMA1] 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] section 2.1).
2.6.1 CT_ConditionalFormattings
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: conditionalFormattings
The CT_ConditionalFormattings complex type specifies conditional formatting information for the worksheet.<43>
Child Elements:
conditionalFormatting: A CT_ConditionalFormatting element (section 2.6.2) that specifies the conditional formatting properties for a range.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_ConditionalFormattings">
<xsd:sequence>
<xsd:element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="1" maxOccurs="unbounded"/>
</xsd:sequence>
</xsd:complexType>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).