[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

cfvo (Conditional Format Value Object)

Describes the values of the interpolation points in a gradient scale.

[Example: This example demonstrates a color scale conditional formatting rule, which defines a color for the minimum value in the range of cell values, a color for the midpoint value, and a color for the maximum value in the in the range of cell values. Information is given about how to define the midpoint. In this case, it is the 50 percent mark.

<colorScale>
<cfvo type="min" val="0"/>
<cfvo type="percent" val="50"/>
<cfvo type="max" val="0"/>
<color rgb="FFFF0000"/>
<color rgb="FFFFFF00"/>
<color rgb="FF00B050"/>
</colorScale>

The first <cfvo> element corresponds with the first <color> definition, and so on.

end example]

Parent Elements

colorScale3.3.1.15); dataBar3.3.1.26); iconSet3.3.1.46)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

 

Attributes

Description

gte (Greater Than Or Equal)

For icon sets, determines whether this threshold value uses the greater than or equal to operator. '0' indicates 'greater than' is used instead of 'greater than or equal to'.

 

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

type (Type)

The type of this conditional formatting value object. For example 'min' and 'max' would be used (in conjunction with @val) to express the lower and upper values to be used in a gradient.

 

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

val (Value)

The value of this conditional formatting value object.

 

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

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

<complexType name="CT_Cfvo">

   <sequence>

   <element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

   </sequence>

   <attribute name="type" type="ST_CfvoType" use="required"/>

   <attribute name="val" type="ST_Xstring" use="optional"/>

   <attribute name="gte" type="xsd:boolean" use="optional" default="true"/>

</complexType>