GrapeCity.Documents.Excel.FormatConditionOperator

Enum FormatConditionOperator

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween, to compare two formulas.

public enum FormatConditionOperator

Fields

Between = 1

Specifes to compare between values. Can only be used if two formulas are provided.

Equal = 3

Specifies values are equal.

Greater = 5

Specifies values are greater than the condition.

GreaterEqual = 7

Specifies values are greater than or equal to the condition.

Less = 6

Specifies values are less than the condition.

LessEqual = 8

Specifies values are less than or equal to the condition.

None = 0

None.

NotBetween = 2

Specifies to check if values are not between the conditions. Can only be used if two formulas are provided.

NotEqual = 4

Specifies values are not equal.