FormatConditions Property

Microsoft Excel Visual Basic

Returns a FormatConditions collection that represents all the conditional formats for the specified range. Read-only.

For more information about returning an individual member of a collection, see Returning an Object from a Collection.

Example

This example modifies an existing conditional format for cells E1:E10.

Worksheets(1).Range("e1:e10").FormatConditions(1) _
    .Modify xlCellValue, xlLess, "=$a$1"