FormatConditions Members
Include Protected Members
Include Inherited Members
Represents the collection of conditional formats for a single range.
The FormatConditions type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
_Default | Reserved for internal use. |
|
Application | Returns an Application object that represents the Microsoft Excel application. |
|
Count | Returns the number of objects in the collection. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. |
|
Parent | Returns the parent object for the specified object. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
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. |
|
GetEnumerator() | (Inherited from IEnumerable.) |
|
GetEnumerator() | |
|
Item | Returns a single object from a collection. |
Top