Class ExcelCFType

Specifies whether the conditional format is based on a cell value or an expression.

Inheritance

System.Object

ExcelCFType

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public sealed class ExcelCFType : Enum

Fields

AboveBelowAverage

Represents conditional formatting rule to highlight the cells that contain values above or below the range average.

Declaration

public const ExcelCFType AboveBelowAverage

Field Value

Type
ExcelCFType

Blank

Represents conditional formatting rule highlights cells that are completely blank.

Declaration

public const ExcelCFType Blank

Field Value

Type
ExcelCFType

CellValue

Represents the Cell Value option for conditional formatting.

Declaration

public const ExcelCFType CellValue

Field Value

Type
ExcelCFType

ColorScale

Represents the ColorScale option for conditional formatting.

Declaration

public const ExcelCFType ColorScale

Field Value

Type
ExcelCFType

ContainsErrors

Represents conditional formatting rule highlights cells that contains errors.

Declaration

public const ExcelCFType ContainsErrors

Field Value

Type
ExcelCFType

DataBar

Represents the DataBar option for conditional formatting.

Declaration

public const ExcelCFType DataBar

Field Value

Type
ExcelCFType

Duplicate

Represents conditional formatting rule to highlight the cells with duplicate values.

Declaration

public const ExcelCFType Duplicate

Field Value

Type
ExcelCFType

Formula

Represents the Formula option for conditional formatting.

Declaration

public const ExcelCFType Formula

Field Value

Type
ExcelCFType

IconSet

Represents the IconSet option for conditional formatting.

Declaration

public const ExcelCFType IconSet

Field Value

Type
ExcelCFType

NoBlank

Represents conditional formatting rule highlights cells that are not blank.

Declaration

public const ExcelCFType NoBlank

Field Value

Type
ExcelCFType

NotContainsErrors

Represents conditional formatting rule highlights cells that does not contains errors.

Declaration

public const ExcelCFType NotContainsErrors

Field Value

Type
ExcelCFType

SpecificText

Represents the Specific Text conditional formatting rule based on the text.

Declaration

public const ExcelCFType SpecificText

Field Value

Type
ExcelCFType

TimePeriod

Represents Time Period conditional formatting rule highlights cells that has date time.

Declaration

public const ExcelCFType TimePeriod

Field Value

Type
ExcelCFType

TopBottom

Represents conditional formatting rule to highlight the top 10 or bottom 10 cells with the values.

Declaration

public const ExcelCFType TopBottom

Field Value

Type
ExcelCFType

Unique

Represents conditional formatting rule to highlight the cells with unique values.

Declaration

public const ExcelCFType Unique

Field Value

Type
ExcelCFType