ConditionalFormatCollection Class

Collection class for objects which derive from ConditionBase.

Syntax

Visual Basic

'Declaration
 
Public Class ConditionalFormatCollection 

C#

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: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2