The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

FormatConditions Object

Office 2007
Represents the collection of conditional formats for a single range.


The FormatConditions collection can contain multiple conditional formats. Each format is represented by a FormatCondition object.

For more information about conditional formats, see the FormatCondition object.

Use the FormatConditions property to return a FormatConditions object. Use the Add method to create a new conditional format, and use the Modify method to change an existing conditional format.


The following example adds a conditional format to cells E1:E10.

Visual Basic for Applications
With Worksheets(1).Range("e1:e10").FormatConditions _
        .Add(xlCellValue, xlGreater, "=$a$1")
    With .Borders
        .LineStyle = xlContinuous
        .Weight = xlThin
        .ColorIndex = 6
    End With
    With .Font
        .Bold = True
        .ColorIndex = 3
    End With
End With