SpreadsheetGear 2017
Modify(FormatConditionType,FormatConditionOperator,String,String) Method






SpreadsheetGear Namespace > IFormatCondition Interface > Modify Method : Modify(FormatConditionType,FormatConditionOperator,String,String) Method
Specifies the new type for this conditional format.
Specifies the new operator for this conditional format.
Specifies the new first formula for this conditional format.
Specifies the new second formula for this conditional format.
Modifies this conditional format with the specified type, operator and formula(s).
Syntax
'Declaration
 
Overloads Sub Modify( _
   ByVal type As FormatConditionType, _
   ByVal formatConditionOperator As FormatConditionOperator, _
   ByVal formula1 As System.String, _
   ByVal formula2 As System.String _
) 
'Usage
 
Dim instance As IFormatCondition
Dim type As FormatConditionType
Dim formatConditionOperator As FormatConditionOperator
Dim formula1 As System.String
Dim formula2 As System.String
 
instance.Modify(type, formatConditionOperator, formula1, formula2)
procedure Modify( 
    type: FormatConditionType;
    formatConditionOperator: FormatConditionOperator;
    formula1: System.String;
    formula2: System.String
); 
function Modify( 
   type : FormatConditionType,
   formatConditionOperator : FormatConditionOperator,
   formula1 : System.String,
   formula2 : System.String
);

Parameters

type
Specifies the new type for this conditional format.
formatConditionOperator
Specifies the new operator for this conditional format.
formula1
Specifies the new first formula for this conditional format.
formula2
Specifies the new second formula for this 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

IFormatCondition Interface
IFormatCondition Members
Overload List