Share via


AcFormatConditionOperator Enumeration

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.