This topic has not yet been rated - Rate this topic

FormatConditions Members (Excel)

Published: July 16, 2012

Represents the collection of conditional formats for a single range.

Name

Description

Add

Adds a new conditional format.

AddAboveAverage

Returns a new AboveAverage object representing a conditional formatting rule for the specified range.

AddColorScale

Returns a new ColorScale object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range.

AddDatabar

Returns a Databar object representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition

Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.

AddTop10

Returns a Top10 object representing a conditional formatting rule for the specified range.

AddUniqueValues

Returns a new UniqueValues object representing a conditional formatting rule for the specified range.

Delete

Deletes the object.

Item

Returns a single object from a collection.

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Count

Returns a Long value that represents the number of objects in the collection.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Parent

Returns the parent object for the specified object. Read-only.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.