Formula2 Property Example

This example changes the formula for conditional format one for cells E1:E10 if the formula specifies “between 5 and 10"

With Worksheets(1).Range("e1:e10").FormatConditions(1)
    If .Operator = xlBetween And _
            .Formula1 = "5" And _
            .Formula2 = "10" Then
        .Modify xlCellValue, xlLess, "10"
    End If
End With