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