Share via


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

  • Operator
    Type: System.Object

    Optional 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.Object

    Optional 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.Object

    Optional Object. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.

See Also

Reference

FormatCondition Interface

FormatCondition Members

Microsoft.Office.Interop.Excel Namespace