Need help comparing dates

Hello group, first of all great site. I find myself with a challenge and am greatful for any assistance that you could provide.

Background:
We have a database running in the background that pushes out dates into excel where management can generate automaticlly.

Objective:
I need to create a macro the compares a row of dates against todays date (date when report is generated) and outputs a colored filled cell. We are currently managing this spreadsheet by changing the colored cell filled manually. Ideally I would like to have this aspect automated.

Specifications:
Compare the dates in a row against today (date report generated) and if the date is up to 7 days late, auto fill a status cell in yellow. If the autopopulated date in the cell exceeds 7 days then status cell is then red.

eg: if report generated on Aug-31-06 and cell is populated by Sept-1-06 then status color should be yellow. If date is Sept-10-06 then status color is red.


Any assistance would be appreciated..thanking you in advance