Share via

FormatCondition.Operator Property

  • Article
Excel Developer Reference

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."

Visual Basic for Applications 
  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