XlCondFmtRule.RuleType Property
Gets the type of the specified conditional formatting rule.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v20.2.Core.dll
NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core
Declaration
Property Value
| Type | Description |
|---|---|
| XlCondFmtType | One of the XlCondFmtType enumeration values indicating the type of the conditional formatting rule. |
Available values:
| 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. |