ConditionalFormatValueObject Class

Conditional Format Value Object.When the object is serialized out as xml, its qualified name is x:cfvo.

Inheritance Hierarchy


Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)


<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class ConditionalFormatValueObject _
    Inherits OpenXmlCompositeElement
Dim instance As ConditionalFormatValueObject
public class ConditionalFormatValueObject : OpenXmlCompositeElement


The following table lists the possible child types:

  • ExtensionList <x:extLst>

[ISO/IEC 29500-1 1st Edition] 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.

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

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

end example]

Parent Elements

colorScale (§; dataBar (§; iconSet (§

Child Elements


extLst (Future Feature Data Storage Area)




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 W3C XML Schema boolean datatype.

type (Type)

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

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

val (Value)

The value of this conditional formatting value object.

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

[Note: The W3C XML Schema definition of this element’s content model (CT_Cfvo) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also


ConditionalFormatValueObject Members

DocumentFormat.OpenXml.Spreadsheet Namespace