FormatCondition.Operator Property (Excel)
Returns a Long value that represents the operator for the conditional format.
Syntax
expression .Operator
expression A variable that represents a FormatCondition object.
Example
This example changes the formula for conditional format one, for cells E1:E10 if the formula specifies "less than 5."
With Worksheets(1).Range("e1:e10").FormatConditions(1)
If .Operator = xlLess And .Formula1 = "5" Then
.Modify xlCellValue, xlBetween, "5", "15"
End If
End With