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