Conditional Formatting-1 week

[Frank]

I have a spreadsheet and in cell B2 is the date the project was created i.e
Feb/10/2010. I then have a column of blank cells that require a date entry.
I need a formula to turn the range of blank cells red if no date has been
entered after 7 days from the creation date.

Any advise??

 

[MarkusSchaber]

Hi, Frank,

I have a spreadsheet and in cell B2 is the date the project was created i..e
Feb/10/2010.  I then have a column of blank cells that require a date entry.  
I need a formula to turn the range of blank cells red if no date has been
entered after 7 days from the creation date.

Any advise??

Yes. The likelyhood of getting a helpful answer will drastically
increase once you post your question in a group where it is on topic.