Conditional Formatting Question

[bergsh]

Hello,
I have been searching the forum and have not been able to find what exactly I am looking for. Nor have I been able to alter what I have found in order to make it fuction as I desire.

I have created a matrix (block of cells) I would like to turn the individual cell in the block of cells red when it is 700 days after the date in the cell.

The block of cells contains the date trained, from todays date I would like to turn the cell red a month before the training is due.

I have tried to add a screen shot of the page but I am not doing something right or that option is no longer available. I will try again though.

Thanks in advance for the help

 

[barry houdini]

OK so, if today is 17th September 2009 then any dates on or before 18th October 2007 (which is exactly 700 days ago), should turn red, tomorrow 19th October 2007 will also turn red?

If dates are in B2:J10 then select that range and use conditional formating with the formula

=(B2<=TODAY()-700)*(B2<>"")

format as red > OK

 

[bergsh]

Thank you so much, that worked exactly like I wanted.

Thanks,
Shawn