You can use the Operator property to return the operator value for the conditional format or data validation of a FormatCondition object.
Setting
The Operator property returns one of the following intrinsic constants.
| acBetween (0) | acLessThan (5) |
| acEqual (2) | acLessThanOrEqual (7) |
| acGreaterThan (4) | acNotBetween (1) |
| acGreaterThanOrEqual (6) | acNotEqual (3) |
The Operator property is available only by using Visual Basicand is read-only.
Remarks
The Operator property's intrinsic constants are used in conjunction with the Expression1 and Expression2 properties and the Add method of the FormatConditions object for conditional formatting and data validation.