Share via

2.6.2 CT_ConditionalFormatting

  • Article

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

Referenced by: CT_ConditionalFormattings

The CT_ConditionalFormatting complex type specifies conditional formatting properties for a range.

Child Elements:

cfRule: A CT_CfRule element (section 2.6.27) that specifies a conditional formatting rule for this range.

xm:sqref: A sqref element (section 2.4.5) that specifies the range this conditional formatting applies to.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2016] section A.2) element that specifies future extensibility for this element.

Attributes:

pivot: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether this conditional formatting is applied only to a PivotTable. MUST be a value from the following table.

Value

Meaning

"true"

The area specified by sqref only includes cells that are part of a PivotTable data area.

"false"

The area specified by sqref includes cells that are not part of a PivotTable data area.

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

 <xsd:complexType name="CT_ConditionalFormatting">
   <xsd:sequence>
     <xsd:element name="cfRule" type="CT_CfRule" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element ref="xm:sqref" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="extLst" minOccurs="0" type="x:CT_ExtensionList"/>
   </xsd:sequence>
   <xsd:attribute name="pivot" type="xsd:boolean" default="false" use="optional"/>
 </xsd:complexType>

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