FormatConditions Property
Applies To
Range object.
Description
Returns a FormatConditions collection that represents all the conditional formats for the specified range. Read-only.
Example
This example modifies an existing conditional format for cells E1:E10.
Worksheets(1).Range("E1:E10").FormatConditions(1) _
.Modify xlCellValue, xlLess, "=$a$1"