FormatConditions Property
TOC
Collapse the table of content
Expand the table of content

Range.FormatConditions Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a FormatConditions collection that represents all the conditional formats for the specified range. Read-only.

expression .FormatConditions

expression A variable that represents a Range object.

This example modifies an existing conditional format for cells E1:E10.

Worksheets(1).Range("e1:e10").FormatConditions(1) _ 
 .Modify xlCellValue, xlLess, "=$a$1"

Concepts

Other resources

Show:
© 2016 Microsoft