FormatConditions.Add method (Excel)

Article
09/13/2021

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.