FormatConditions.Item Method

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a FormatConditions object.

Parameters

Return Value
An Object value that represents an object contained by the collection.

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

See Also

• FormatConditions Object
• FormatConditions Object Members