my blank cells are fomatting as well

Occasional Visitor

I have a column of cells some contain dates, some are blank.


I would like cells with dates over 11 months old to format orange


I would like the cells with dates over one year old to format red


Blank cells should not change colour.

Everything I have found changes blank cells also, which does not work for my purposes, is there a way to get this result?

2 Replies

@Charity K Gardiner 

You may use the rule with the formula like


@Charity K Gardiner 

Add a new rule to format all cells that are equal to ="" with a custom format that has no color.


(alternatively, edit the existing rules to use formulas to determine which cells to format, but that is more work)