FormatConditions Object

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

See also:

• Excel Object Model Reference
• FormatConditions Object Members