XlCondFmtType Enum

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

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public enum XlCondFmtType

VB.NET

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:

• XlCondFmtRule.RuleType