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

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

Parent Elements


Child Elements


<cfRule> (Conditional Formatting Rule)


<extLst> (Future Feature Data Storage Area)




<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">
	<element name="cfRule" type="CT_CfRule" minOccurs="1" maxOccurs="unbounded"/>
	<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
	<attribute name="pivot" type="xsd:boolean" default="false"/>
	<attribute name="sqref" type="ST_Sqref"/>