<conditionalFormats>
(Conditional Formats)
Represents the collection of conditional formats applied to a PivotTable.
example:
<sh:conditionalFormats count="1"> <sh:conditionalFormat priority="1"> <sh:pivotAreas count="1"> <sh:pivotArea type="data" collapsedLevelsAreSubtotals="1"> <sh:references count="5"> <sh:reference field="4294967294" count="1" selected="0"> <sh:x v="0"/> </sh:reference> <sh:reference field="2" count="1" selected="0"> <sh:x v="0"/> </sh:reference> <sh:reference field="14" count="1" selected="0"> <sh:x v="0"/> </sh:reference> <sh:reference field="15" count="2" selected="0"> <sh:x v="2"/> <sh:x v="3"/> </sh:reference> </sh:references> </sh:pivotArea> </sh:pivotAreas> </sh:conditionalFormat> </sh:conditionalFormats>
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
Attributes |
Description |
---|---|
|
Specifies the number of conditional formats defined for the PivotTable. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_ConditionalFormats">
<sequence>
<element name="conditionalFormat" maxOccurs="unbounded" type="CT_ConditionalFormat"/>
</sequence>
<attribute name="count" type="xsd:unsignedInt" default="0"/>
</complexType>