SpreadsheetGear 2023
Add(FormatConditionType,FormatConditionOperator,String,String) Method


SpreadsheetGear Namespace > IFormatConditions Interface > Add Method : Add(FormatConditionType,FormatConditionOperator,String,String) Method
Specifies the type for the new conditional format.
Specifies the operator of the conditional format.
Specifies the first formula of the conditional format.
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
'Declaration
 
Overloads Function Add( _
   ByVal type As FormatConditionType, _
   ByVal formatConditionOperator As FormatConditionOperator, _
   ByVal formula1 As System.String, _
   ByVal formula2 As System.String _
) As IFormatCondition
'Usage
 
Dim instance As IFormatConditions
Dim type As FormatConditionType
Dim formatConditionOperator As FormatConditionOperator
Dim formula1 As System.String
Dim formula2 As System.String
Dim value As IFormatCondition
 
value = instance.Add(type, formatConditionOperator, formula1, 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 Value

The new conditional format.
Requirements

Target Platforms: 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

See Also

Reference

IFormatConditions Interface
IFormatConditions Members
Overload List