FormatCondition.Operator Property

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

See also:

• FormatCondition Object
• FormatCondition Object Members