[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

activePresent: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that MUST be "true" if, and only if, a formula is present in f and type is "colorScale", "dataBar", or "iconSet".

id: An ST_Guid ([ISO/IEC29500-1:2011] section 22.9.2.4) attribute that identifies this conditional formatting rule. If the priority attribute does not exist, and this attribute exists, this attribute is used to match this CT_CfRule element to the corresponding CT_CfRule ([ISO/IEC29500-4:2011] section A.2) element. If neither the priority attribute nor this attribute exists, this CT_CfRule and its child CT_DataBar element MUST be ignored.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.28 CT_IconSet

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_CfRule

A complex type that specifies the properties of a conditional formatting rule that uses an icon set. The first cfvo element following this element MUST be ignored. There MUST be greater than or equal to three cfvo elements and MUST be less than or equal to five cfvo elements following this complex type.

Child Elements:

cfvo: A CT_Cfvo element that specifies a threshold value between each icon in the icon set.

cfIcon: A CT_CfIcon element that specifies a particular icon to use within an icon set. This element MUST be present if and only if custom equals "true".

Attributes:

iconSet: An ST_IconSetType attribute that specifies the icon set used.

showValue: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the cells in the applied range display the icon and cell value, or the icon only.

Value	Meaning
"true"	The icon and cell value are shown in the cell.
"false"	Only the icon is shown in the cell.

percent: Undefined and MUST be ignored.

reverse: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the icons in the icon set specified in iconSet are shown in reverse order. If custom equals "true" this value MUST be ignored.

Value	Meaning
"true"	The icons specified in iconSet are shown in reverse order.
"false"	The icons specified in iconSet are shown in the order defined by the icon set.

custom: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a custom set of icons is used. If this value is "true", there MUST be the same number of cfIcon elements as cfvo elements and the icons specified by the cfIcon elements are used rather than those specified by iconSet. If this value is "false", there MUST be 0 cfIcon elements.

Value	Meaning
"false"	No custom set of icons is used.
"true"	A custom set of icons is used.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.29 CT_ColorScale

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_CfRule

A complex type that specifies a color scale used in conditional formatting.

Child Elements:

cfvo: A CT_Cfvo element that specifies the cell values corresponding to the interpolation colors of the color scale. The CT_ColorScale MUST have either two or three child CT_Cfvo elements.

If there are two child CT_Cfvo elements present, the first child CT_Cfvo element specifies the cell value corresponding to the beginning color of the color scale. The second child CT_Cfvo element specifies the cell value corresponding to the end color of the color scale.

If there are three child CT_Cfvo elements present, the first child CT_Cfvo element specifies the cell value corresponding to the beginning color of the color scale. The second child CT_Cfvo element specifies the cell value corresponding to the midpoint color of the color scale. The third child CT_Cfvo element specifies the cell value corresponding to the end color of the color scale.