conditional formatting cell if blank within a time frame

[krisnowicki]

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

[grizzly6969]

try this in D1 formula is

=and(A1=today()-30,D1=0)

format red
in E1

=and A1=today()-60,E1=0)

format red
in F1

=and (A1=today()-90,F1=0)

format red

[krisnowicki]

this returns (FALSE)

[grizzly6969]

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

[grizzly6969]

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