Skip to main content

XlCondFmtRule.RuleType Property

Gets the type of the specified conditional formatting rule.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public XlCondFmtType RuleType { get; }

Property Value

Type Description
XlCondFmtType

One of the XlCondFmtType enumeration values indicating the type of the conditional formatting rule.

Available values:

Show 18 items
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.

See Also