Cell colour change.
 

Please help.
I have 3 cells next to each other on a spread sheet. First cell has an order
date the second cell has a delivery date. I want the third cell to display a
differant colour when the todays date gets within a set amount of days of the
delivery date. Like a status cell. E.g Goes green within a week of the
date/goes red within 2 days of the delivery date.
please please help me.....