Item Method (FormatConditions Collection)

Applies To

FormatConditions collection object.

Description

Returns a single FormatCondition object from a FormatConditions collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a FormatConditions object.

Index Required Variant. The index number of the conditional format.

Example

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

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