FormatCondition.Modify Method
Modifies an existing conditional format.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub Modify ( _
Type As XlFormatConditionType, _
Operator As Object, _
Formula1 As Object, _
Formula2 As Object _
)
'Usage
Dim instance As FormatCondition
Dim Type As XlFormatConditionType
Dim Operator As Object
Dim Formula1 As Object
Dim Formula2 As Object
instance.Modify(Type, Operator, Formula1, _
Formula2)
void Modify(
XlFormatConditionType Type,
Object Operator,
Object Formula1,
Object Formula2
)
Parameters
Type
Type: Microsoft.Office.Interop.Excel.XlFormatConditionTypeRequired XlFormatConditionType. Specifies whether the conditional format is based on a cell value or an expression. Can be one of the following XlFormatCondition constants:
xlCellValue
xlExpression
Operator
Type: System.ObjectOptional XlFormatConditionOperator. The conditional format operator. Can be one of the following XlFormatConditionOperator constants:
xlBetween
xlEqual
xlGreater
xlGreaterEqual
xlLess
xlLessEqual
xlNotBetween
xlNotEqual
If Type, is xlExpression, the Operator argument is ignored.
Formula1
Type: System.ObjectOptional Object. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.
Formula2
Type: System.ObjectOptional Object. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.