Version

ConditionalFormatCollection Class

Collection class for objects which derive from ConditionBase.
Syntax
public class ConditionalFormatCollection
Remarks

To enable a conditional format on a region of worksheet cells, add a ConditionBase-derived instance to this collection.

This collection exposes an Add method for each type of conditional format available.

For example, to add a conditional format which is based on a value and a logical operator, use the AddOperatorCondition method.

The conditional formatting classes which derive from ConditionalFormatBase expose a CellFormat property, which in turn exposes properties which control the visual attributes of cells which meet the criteria defined by the condition. This format is applied to cells with a value which passes the condition.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also