Adds a new conditional format.
Syntax
expression.Add (Type, Operator, Formula1, Formula2)
expression A variable that represents a FormatConditions object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Type | Required | XlFormatConditionType | Specifies whether the conditional format is based on a cell value or an expression. |
| Operator | Optional | Variant | The conditional format operator. Can be one of the following XlFormatConditionOperator constants: xlBetween, xlEqual, xlGreater, xlGreaterEqual, xlLess, xlLessEqual, xlNotBetween, or xlNotEqual. If Type is xlExpression, the Operator argument is ignored. |
| Formula1 | Optional | Variant | The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula. |
| Formula2 | Optional | Variant | The value or expression associated with the second part of the conditional format when Operator is xlBetween or xlNotBetween (otherwise, this argument is ignored). Can be a constant value, a string value, a cell reference, or a formula. |
Return value
A FormatCondition object that represents the new conditional format.
Remarks
Use the Modify method to modify an existing conditional format, or use the Delete method to delete an existing format before adding a new one.
Example
This example adds a conditional format to cells E1:E10.
With Worksheets(1).Range("e1:e10").FormatConditions.Add(xlCellValue, xlGreater, "=$a$1")
With .Borders
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 6
End With
With .Font
.Bold = True
.ColorIndex = 3
End With
End With