Class FormatConditions (Excel VBA)

The class FormatConditions represents the collection of conditional formats for a single range.

Class Range gives access to class FormatConditions.

Dim fcds as FormatConditions
Set fcds = ActiveCell.FormatConditions

For Each

Here is an example of processing the FormatConditions items in a collection.

Dim aaeFormatCondition As AboveAverage
For Each aaeFormatCondition In ActiveCell.FormatConditions
	
Next aaeFormatCondition

Methods

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Add - Adds a new conditional format.

AddAboveAverage - Returns a new AboveAverage aboveaverage representing a conditional formatting rule for the specified range.

AddColorScale - Returns a new ColorScale colorscale 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 databar representing a data bar conditional formatting rule for the specified range.

AddIconSetCondition - Returns a new IconSetCondition iconsetcondition that represents an icon set conditional formatting rule for the specified range.

AddTop10 - Returns a Top10 top10 representing a conditional formatting rule for the specified range.

AddUniqueValues - Returns a new UniqueValues uniquevalues representing a conditional formatting rule for the specified range.

Delete - Deletes the object.

Item - Returns a single object from a collection.

Properties

Count returns a Long value that represents the number of objects in the collection.

Count returns a Long value that represents the number of objects in the collection.

Count returns a Long value that represents the number of objects in the collection.

Count returns a Long value that represents the number of objects in the collection.

Count returns a Long value that represents the number of objects in the collection.

Count returns a Long value that represents the number of objects in the collection.

Count returns a Long value that represents the number of objects in the collection.