FormatConditions.Add Method (Excel)

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

See also

FormatConditions Object