ConditionalFormatValues Enumeration

Conditional Format Type

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

Syntax

'Declaration
Public Enumeration ConditionalFormatValues
'Usage
Dim instance As ConditionalFormatValues
public enum ConditionalFormatValues

Members

Member name Description
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".

See Also

Reference

DocumentFormat.OpenXml.Spreadsheet Namespace