FormatConditions object (Excel)

Represents the collection of conditional formats for a single range.

Remarks

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.

Example

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

Methods

• Add
• AddAboveAverage
• AddColorScale
• AddDataBar
• AddIconSetCondition
• AddTop10
• AddUniqueValues
• Delete
• Item

Properties

• Application
• Count
• Creator
• Parent

See also

• Excel Object Model Reference

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.