FormatConditions Object Members

  • Article
Excel Developer Reference

Represents the collection of conditional formats for a single range.

Methods

  Name Description
Bb242268.methods(en-us,office.12).gif Add Adds a new conditional format.
Bb242268.methods(en-us,office.12).gif AddAboveAverage Returns a new AboveAverage object representing a conditional formatting rule for the specified range.
Bb242268.methods(en-us,office.12).gif AddColorScale Returns a new ColorScale object representing a color scale conditional formatting rule for the selected range.
Bb242268.methods(en-us,office.12).gif AddDatabar Returns a Databar object representing a data bar conditional formatting rule for the specified range.
Bb242268.methods(en-us,office.12).gif AddIconSetCondition Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range.
Bb242268.methods(en-us,office.12).gif AddTop10 Returns a Top10 object representing a conditional formatting rule for the specified range.
Bb242268.methods(en-us,office.12).gif AddUniqueValues Returns a new UniqueValues object representing a conditional formatting rule for the specified range.
Bb242268.methods(en-us,office.12).gif Delete Deletes the object.
Bb242268.methods(en-us,office.12).gif Item Returns a single object from a collection.

Properties

  Name Description
Bb242268.properties(en-us,office.12).gif 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.
Bb242268.properties(en-us,office.12).gif Count Returns a Long value that represents the number of objects in the collection.
Bb242268.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.