| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Range.FormatConditions property (Excel) |
vbaxl10.chm144226 |
|
|
676ffcc6-f08d-9f91-78af-7b98f8b77dca |
05/10/2019 |
medium |
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"[!includeSupport and feedback]