ApiFormatConditions

Represents the ApiFormatConditions class.

Properties

Name	Type	Description
Count	number	Returns the number of conditional formatting rules in the collection.
Parent	ApiRange	Returns the parent range object associated with the current conditional formatting collection.

Methods

Method	Returns	Description
Add	ApiFormatCondition | null	Adds a new format condition to the collection.
AddAboveAverage	ApiAboveAverage | null	Adds a new above average conditional formatting rule to the collection.
AddColorScale	ApiColorScale | null	Adds a new color scale conditional formatting rule to the collection.
AddDatabar	ApiDatabar | null	Adds a new data bar conditional formatting rule to the collection.
AddIconSetCondition	ApiIconSetCondition | null	Adds a new icon set conditional formatting rule to the collection.
AddTop10	ApiTop10 | null	Adds a new top 10 conditional formatting rule to the collection.
AddUniqueValues	ApiUniqueValues | null	Adds a new unique values conditional formatting rule to the collection.
Delete	None	Deletes all format conditions from the collection.
GetCount	number	Returns the number of conditional formatting rules in the collection.
GetItem	ApiFormatCondition | null	Returns a format condition by its index.
GetParent	ApiRange	Returns the parent range object associated with the current conditional formatting collection.