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.