ConditionalFormatValues enumeration

Office 2013 and later

Conditional Format Type

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
Expression Expression. When the item is serialized out as xml, its value is "expression".
CellIs Cell Is. When the item is serialized out as xml, its value is "cellIs".
ColorScale Color Scale. When the item is serialized out as xml, its value is "colorScale".
DataBar Data Bar. When the item is serialized out as xml, its value is "dataBar".
IconSet Icon Set. When the item is serialized out as xml, its value is "iconSet".
Top10 Top 10. When the item is serialized out as xml, its value is "top10".
UniqueValues Unique Values. When the item is serialized out as xml, its value is "uniqueValues".
DuplicateValues Duplicate Values. When the item is serialized out as xml, its value is "duplicateValues".
ContainsText Contains Text. When the item is serialized out as xml, its value is "containsText".
NotContainsText Does Not Contain Text. When the item is serialized out as xml, its value is "notContainsText".
BeginsWith Begins With. When the item is serialized out as xml, its value is "beginsWith".
EndsWith Ends With. When the item is serialized out as xml, its value is "endsWith".
ContainsBlanks Contains Blanks. When the item is serialized out as xml, its value is "containsBlanks".
NotContainsBlanks Contains No Blanks. When the item is serialized out as xml, its value is "notContainsBlanks".
ContainsErrors Contains Errors. When the item is serialized out as xml, its value is "containsErrors".
NotContainsErrors Contains No Errors. When the item is serialized out as xml, its value is "notContainsErrors".
TimePeriod Time Period. When the item is serialized out as xml, its value is "timePeriod".
AboveAverage Above or Below Average. When the item is serialized out as xml, its value is "aboveAverage".
Show: