XlCondFmtType Enum
Lists the types of the conditional formatting operators used in the conditional formatting rule.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v20.2.Core.dll
NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core
Declaration
Members
| Name | Description |
|---|---|
AboveOrBelowAverage
|
Format cells whose values are above or below the average for all values in the range. |
BeginsWith
|
Format cells that begin with the specified text string. |
CellIs
|
Format a cell using the relational operator. |
ColorScale
|
Format cells using color scales. |
ContainsBlanks
|
Format blank or empty cells. |
ContainsErrors
|
Format cells that contain errors. |
ContainsText
|
Format cells that contain the specified text string. |
DataBar
|
Format cells using data bars. |
DuplicateValues
|
Format cells with duplicate values. |
EndsWith
|
Format cells that end with the specified text string. |
Expression
|
Format cells using an expression. |
IconSet
|
Format cells using icon set. |
NotContainsBlanks
|
Format non-empty cells. |
NotContainsErrors
|
Format cells that do not contain errors. |
NotContainsText
|
Format cells that do not contain the specified text string. |
TimePeriod
|
Format cells that contain dates in the specified time period. |
Top10
|
Format cells values that fall in the top/bottom N bracket. |
UniqueValues
|
Format cells that contains unique values. |
Related API Members
The following properties accept/return XlCondFmtType values: