Formula2 Property

Applies To

FormatCondition object, Validation object.

Description

Returns the value or expression associated with the second part of a conditional format or data validation. Used only when the data validation conditional format Operator property is xlBetween or xlNotBetween. Can be a constant value, a string value, a cell reference, or a formula. Read-only String.

See Also

Add method (FormatConditions collection), Formula1 property, Modify method (FormatCondition object), Operator 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