FormatConditions Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.