If date older than today color cell RED

Hi guys,

I've been around excel for a while but never tried building any meaningful sheet until now :-)

I need your help.

Column B is populated with dates only. I want the cell to the right (on column C) to become:

- RED -- if the date in column B is equal to a week from the current date or older (basically older than 7 days from now)
- GREEN -- if the date in column B is greater by 8 days from the current date.


For example:
Today (current date) is Sep-18-2008:

Jan-02-2008 RED
Sep-18-2008 RED
Sep-22-2008 RED
Sep-30-2008 GREEN
Oct-11-2008 GREEN

Thank you!

Choco