FormatConditions Members (Excel)

Represents the collection of conditional formats for a single range.

Methods

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.