XlCondFmtType Enum

Lists the types of the conditional formatting operators used in the conditional formatting rule.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll

Declaration

public enum XlCondFmtType

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:

See Also