[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

conditionalFormat (Conditional Formatting)

Represents the conditional formatting defined in the PivotTable.

Parent Elements

conditionalFormats3.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>