AcFormatConditionOperator Enumeration

Access Developer Reference

Specifies the operator to apply when using the Add method to create a conditional format.

Name Value Description
acBetween 0 The value must be between the values specified by the Expression1 and Expression2 arguments.
acEqual 2 The value must equal to the value specified by the Expression1 argument.
acGreaterThan 4 The value must be greater than the value specified by the Expression1 argument.
acGreaterThanOrEqual 6 The value must be greater than or equal to the value specified by the Expression1 argument.
acLessThan 5 The value must be less than the value specified by the Expression1 argument.
acLessThanOrEqual 7 The value must be less than or equal to the value specified by the Expression1 argument.
acNotBetween 1 The value must not be between the values specified by the Expression1 and Expression2 arguments.
acNotEqual 3 The value must not be equal to the value specified by the Expression1 argument.