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"