conditional formatting cell if blank within a time frame

I am tracking a time line of how files move through my office....

So at inception we have a date and I would like the cells to color code if there is no activity with x days

so like below ... if the cells are blank at the day value then they change color


Is this possible?


C1
04/05/11
D1
Red at 30 days
E1
red at 60 days
F1
red at 90 days

try this in D1 formula is

Please Login or Register  to view this content.

format red
in E1

Please Login or Register  to view this content.

format red
in F1

Please Login or Register  to view this content.

format red

this returns (FALSE)

sorry --- replace A1 with C1 >>> if this does not work for you check out this file

you must enter this formula in -- conditional format / new rule / use a formula to determine which cells to format >>> apply formula and format your colour