ConditionalFormat

Description

A ConditionalFormat object represents a conditional format that Excel will apply to a cell or group of cells if a specified condition is met. Each ConditionalFormat object contains up to three Condition and a Range object representing the set of cells on which the conditions will be tested.

C#

vb.net

Remarks

To create a ConditionalFormat, call the Workbook object's CreateConditionalFormat method.

Examples

C#

vb.net

Properties

Name	Description
Count	Returns the number of Condition objects in the current ConditionalFormat object.
Range	Returns the Range of cells that is conditionally formatted by the current ConditionalFormat object.

Indexers

Name	Description
Item(Int32)	Returns the Condition object at the specified 0-based index.

Methods

Name	Description
CreateCondition(Comparison, String)	Creates a Condition of the specified ComparisonType.
CreateCondition(Comparison, String, String)	Creates a Condition of the specified ComparisonType.
RemoveCondition(Int32)	Removes the Condition at the specified index from the conditional format.
RemoveCondition(Condition)	Removes the specified Condition from the ConditionalFormat object.

Space Shortcuts

Page tree