<conditionalFormatting> (Conditional Formatting)

A Conditional Format is a format, such as cell shading or font color, that a spreadsheet applicaiton can automatically apply to cells if a specified condition is true. This collection expresses conditional formatting rules applied to a particular cell or range.

example: 
<conditionalFormatting sqref="C3:C8">
  <cfRule type="top10" dxfId="1" priority="3" rank="2"/>
</conditionalFormatting>

Parent Elements

<worksheet> (§3.3.1.96)

Child Elements

Subclause

<cfRule> (Conditional Formatting Rule)

§3.3.1.9

<extLst> (Future Feature Data Storage Area)

§3.2.10

Attributes

Description

<pivot> (PivotTable Conditional Formatting)

Flag indicating if this is conditional formatting associated with a PivotTable.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<sqref> (Sequence of Refernces)

Range over which these conditional formatting rules apply.

The possible values for this attribute are defined by the ST_Sqref simple type (§3.18.78).

The following XML Schema fragment defines the contents of this element:

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