Changed Event (ConditionalFormattingModel)

Occurs when the user makes a change to the model that affects the conditional formatting of cells of the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Event Changed As EventHandler(Of ConditionalFormattingModelEventArgs)

'Usage
 
Dim instance As ConditionalFormattingModel
Dim handler As EventHandler(Of ConditionalFormattingModelEventArgs)
 
AddHandler instance.Changed, handler

public event EventHandler<ConditionalFormattingModelEventArgs> Changed

Event Data

The event handler receives an argument of type ConditionalFormattingModelEventArgs containing data related to this event. The following ConditionalFormattingModelEventArgs properties provide information specific to this event.

Property	Description
CellRanges	Gets the affected cell ranges.
Column	Gets the column index.
ColumnCount	Gets the number of columns.
ConditionalFormattings	Gets the affected conditional formattings.
IsAffectedLayout	Indicates if the change has affected the conditional formatting layout.
Row	Gets the row index.
RowCount	Gets the number of rows.
TargetColumn	Gets the target column index.
TargetRow	Gets the target row index.
Type	Gets the type of Change event.

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ConditionalFormattingModel Class
ConditionalFormattingModel Members