Conditional Formatting-1 week

  • Thread starter Thread starter Frank
  • Start date Start date
F

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??
 
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??
Click to expand...

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