FormatConditions Methods (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Methods
Name |
Description |
---|---|
Adds a new conditional format. |
|
Returns a new AboveAverage object representing a conditional formatting rule for the specified range. |
|
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. |
|
Returns a Databar object representing a data bar conditional formatting rule for the specified range. |
|
Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range. |
|
Returns a Top10 object representing a conditional formatting rule for the specified range. |
|
Returns a new UniqueValues object representing a conditional formatting rule for the specified range. |
|
Deletes the object. |
|
Returns a single object from a collection. |