FormatConditions Members

Represents the collection of conditional formats for a single range.

The following tables list the members exposed by the FormatConditions type.

Public Properties

	Name	Description
	_Default
	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

Public 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.
	GetEnumerator
	Item	Returns a single object from a collection.

Top

See Also

Reference

FormatConditions Interface
Microsoft.Office.Interop.Excel Namespace