SpreadsheetGear
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

Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 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.