corelibraries-devexpress-dot-export-dot-xl-3db58ded.md
Lists the types of the conditional formatting operators used in the conditional formatting rule.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public enum XlCondFmtType
Public Enum XlCondFmtType
| 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.
|
The following properties accept/return XlCondFmtType values:
See Also