FormatCondition Object

Description

Represents a conditional format. The FormatCondition object is a member of the FormatConditions collection. The FormatConditions collection can contain up to three conditional formats for a given range.

Using the FormatCondition Object

Use FormatConditions(index), where index is the index number of the conditional format, to return a FormatCondition object. The following example sets format properties for an existing conditional format for cells E1:E10.

With Worksheets(1).Range("E1:E10").FormatConditions(1)
    With .Borders
        .LineStyle = xlContinuous
        .Weight = xlThin
        .ColorIndex = 6
    End With
    With .Font
        .Bold = True
        .ColorIndex = 3
    End With
End With

Remarks

Use the Add method to create a new conditional format. If you try to create more than three conditional formats for a single range, the Add method fails. If a range has three formats, you can use the Modify method to change one of the formats, or you can use the Delete method to delete a format and then use the Add method to create a new format.

Use the Font, Border, and Interior properties of the FormatCondition object to control the appearance of formatted cells. Some properties of these objects aren't supported by the conditional format object model. The properties that can be used with conditional formatting are listed in the following table.

Object	Properties

Font	Bold Color ColorIndex FontStyle Italic Strikethrough Underline The accounting underline styles cannot be used.

(continued)

Object	Properties

Border	Bottom Color Left Right Style The following border styles can be used (all others aren't supported): xlNone, xlSolid, xlDash, xlDot, xlDashDot, xlDashDotDot, xlGray50, xlGray75, and xlGray25. Top Weight The following border weights can be used (all others aren't supported): xlWeightHairline and xlWeightThin.
Interior	Color ColorIndex Pattern PatternColorIndex

Properties

Application property, Borders property, Creator property, Font property, Formula1 property, Formula2 property, Interior property, Operator property, Parent property, Type property.

Methods

Delete method, Modify method (FormatCondition object).