[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
conditionalFormat (Conditional Formatting)
Represents the conditional formatting defined in the PivotTable.
Parent Elements |
conditionalFormats (§3.10.1.19) |
Child Elements |
Subclause |
extLst (Future Feature Data Storage Area) |
§3.2.10 |
pivotAreas (Pivot Areas) |
§3.10.1.66 |
Attributes |
Description |
priority (Priority) |
Specifies the priority of PivotTable conditional formatting rule.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
scope (Conditional Formatting Scope) |
Specifies the scope of PivotTable conditional formatting rule.
The possible values for this attribute are defined by the ST_Scope simple type (§3.18.69). |
type (Conditional Formatting Rule Type) |
Specifies the type of PivotTable conditional formatting rule. See associated simple type definition for details.
The possible values for this attribute are defined by the ST_Type simple type (§3.18.84). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_ConditionalFormat">
<sequence>
<element name="pivotAreas" type="CT_PivotAreas"/>
<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
</sequence>
<attribute name="scope" type="ST_Scope" default="selection"/>
<attribute name="type" type="ST_Type" default="none"/>
<attribute name="priority" use="required" type="xsd:unsignedInt"/>
</complexType>