내보내기(0) 인쇄
모두 확장

FormatConditions.Item Method (Excel)

Office 2010

Returns a single object from a collection.

.Item(Index)

A variable that represents a FormatConditions object.

Parameters

Name

Required/Optional

Data Type

Description

Index

필수

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
표시:
© 2014 Microsoft