Enum ComparisonOperatorType

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

The Comparison operator for conditional formatting in Excel.

public enum ComparisonOperatorType

Fields

Between = 1

Represents between option for comparison in conditional formatting.

Equal = 3

Represents equal to option for comparison in conditional formatting.

Greater = 5

Represents greater than option for comparison in conditional formatting.

GreaterOrEqual = 7

Represents greater than or equal to option for comparison in conditional formatting.

Less = 6

Represents less than option for comparison in conditional formatting.

LessOrEqual = 8

Represents less than or equal to option for comparison in conditional formatting.

None = 0

Represents no option for comparison in conditional formatting.

NotBetween = 2

Represents not between option for comparison in conditional formatting.

NotEqual = 4

Represents not equal to option for comparison in conditional formatting.