xlFormatConditionOperator

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

xlBetweenBetween
Can be used only if two formulas are provided (1)
xlEqualEqual (3)
xlGreaterGreater than (5)
xlGreaterEqualGreater than or equal to (7)
xlLessLess than (6)
xlLessEqualLess than or equal to (8)
xlNotBetweenNot between
Can be used only if two formulas are provided (2)
xlNotEqualNot equal (4)

xlBetween
Between
Can be used only if two formulas are provided (1)
xlEqual
Equal (3)
xlGreater
Greater than (5)
xlGreaterEqual
Greater than or equal to (7)
xlLess
Less than (6)
xlLessEqual
Less than or equal to (8)
xlNotBetween
Not between
Can be used only if two formulas are provided (2)
xlNotEqual
Not equal (4)


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top