Add Method

Adds a new conditional format to the represented range with the specified type, operator and formula(s).

[Visual Basic]
Overridable Function Add( _
   ByVal type As FormatConditionType, _
   ByVal formatConditionOperator As FormatConditionOperator, _
   ByVal formula1 As String, _
   ByVal formula2 As String _
) As IFormatCondition

[C#]
virtual IFormatCondition Add( 
   FormatConditionType type,
   FormatConditionOperator formatConditionOperator,
   string formula1,
   string formula2
);

[C++]
virtual IFormatCondition* Add( 
   FormatConditionType type,
   FormatConditionOperator formatConditionOperator,
   string* formula1,
   string* formula2
) 

[C++/CLI]
virtual IFormatCondition^ Add( 
   FormatConditionType type,
   FormatConditionOperator formatConditionOperator,
   String^ formula1,
   String^ formula2
) 

Parameters

type

Specifies the type for the new conditional format.

formatConditionOperator

Specifies the operator of the conditional format.

formula1

Specifies the first formula of the conditional format.

formula2

Specifies the second formula of the conditional format.

Return Type

The new conditional format.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IFormatConditions Interface  | IFormatConditions Members

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.