Export (0) Print
Expand All

FormatConditions.Item Method (Excel)

Returns a single object from a collection.

expression .Item(Index)

expression A variable that represents a FormatConditions object.

Parameters

Name

Required/Optional

Data Type

Description

Index

Required

Variant

The name or index number for the object.

Return Value

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

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

Community Additions

ADD
Show:
© 2014 Microsoft