XlFormatConditionOperator Enum

Definition

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

public enum class XlFormatConditionOperator
public enum XlFormatConditionOperator
Public Enum XlFormatConditionOperator
Inheritance
XlFormatConditionOperator

Fields

xlBetween 1

Between. Can only be used if two formulas are provided.

xlEqual 3

Equal.

xlGreater 5

Greater than.

xlGreaterEqual 7

Greater than or equal to.

xlLess 6

Less than.

xlLessEqual 8

Less than or equal to.

xlNotBetween 2

Not between. Can only be used if two formulas are provided.

xlNotEqual 4

Not equal.

Applies to