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.
For more information about conditional formats, see the 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 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