FormatCondition.Modify (Excel)

Modifies an existing conditional format.

Modify (Type, Operator, Formula1, Formula2, String, Operator2)


ActiveCell.FormatConditions(1).Modify Type:=xlAboveAverageCondition

Arguments

The following argument is required

Type (XlFormatConditionType) - Specifies whether the conditional format is based on a cell value or an expression.

Here you can find possible values for XlFormatConditionType

Optional arguments

The following arguments are optional

Operator (XlFormatConditionType) - An XlFormatConditionOperator value that represents the conditional format operator. This parameter is ignored if Type is set to xlExpression.

Here you can find possible values for XlFormatConditionType

Formula1 (String) - The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.

Formula2 (String) - The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.

String

Operator2 - XlFormatConditionOperator


Possible values are

xlBetween Between. Can be used only if two formulas are provided.
xlEqual Equal.
xlGreater Greater than.
xlGreaterEqual Greater than or equal to.
xlLess Less than.
xlLessEqual Less than or equal to.
xlNotBetween Not between. Can be used only if two formulas are provided.
xlNotEqual Not equal.