I am creating a spreadsheet which is a checklist for a shipping processs.

At the top I key in customer name and date the shipping process starts- let
say Feb/15/2010. I require a number of documents that prompt other portions
of the process. Therefore I need an indicator if I do not receive these
within 7 days of the start date ie:

Column 1 Column 2
Date received Date verified

If column 1 remains blank (no date entered) and is past the start date by 7
days I would like it to turn red.

NEXT if there is a date entered in that cell I need an additional cell to
turn another colour prompting the next step...confusing??

Any help would be greatly appreciated!!!

Thanks