Enum ConditionalFormatType

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

Conditional formatting type.

public enum ConditionalFormatType

Fields

Average = 11

Represents the Average option for conditional formatting.

BeginsWith = 6

Represents the BeginsWith option for conditional formatting.

CellValue = 1

Represents the Cell Value Is option for conditional formatting.

ColorScale = 5

Represents the ColorScale option for conditional formatting.

ContainsBlanks = 12

Represents the ContainsBlanks option for conditional formatting.

ContainsErrors = 13

Represents the ContainsErrors option for conditional formatting.

ContainsText = 7

Represents the ContainsText option for conditional formatting.

DataBar = 3

Represents the DataBar option for conditional formatting.

DuplicateValues = 14

Represents the DuplicateValues option for conditional formatting.

EndsWith = 8

Represents the EndsWith option for conditional formatting.

Formula = 2

Represents the Formula Is option for conditional formatting.

IconSet = 4

Represents the IconSet option for conditional formatting.

NotContainsBlanks = 15

Represents the NotContainsBlanks option for conditional formatting.

NotContainsErrors = 16

Represents the NotContainsErrors option for conditional formatting.

NotContainsText = 9

Represents the NotContainsText option for conditional formatting.

TimePeriod = 17

Represents the TimePeriod option for conditional formatting.

TopBottom = 10

Represents the TopBottom option for conditional formatting.

UniqueValues = 18

Represents the UniqueValues option for conditional formatting.