SpreadsheetGear 2010
Add Method
See Also  Send Feedback
SpreadsheetGear Namespace > IFormatConditions Interface : Add Method

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.
Adds a new conditional format to the represented range with the specified type, operator and formula(s).

Syntax

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

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 Value

The new conditional format.

Requirements

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

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.