FormatConditions object (Excel)

Represents the collection of conditional formats for a single range.


The FormatConditions collection can contain multiple conditional formats. Each format is represented by a FormatCondition object.

Use the FormatConditions property to return a FormatConditions object. Use the Add method to create a new conditional format, and use the Modify method of the FormatCondition object to change an existing conditional format.


The following 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

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.