Formula1 Property
Applies To
FormatCondition object, Validation object.
Description
Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. Read-only String.
See Also
Add method (FormatConditions collection), Formula2 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 "less than 5."
With Worksheets(1).Range("E1:E10").FormatConditions(1)
If .Operator = xlLess And .Formula1 = "5" Then
.Modify xlCellValue, xlLess, "10"
End If
End With