Hi, I need help in changing color of the cell based on a date. I've already read several threads here but I am a novice and don't quite get it.

I use Excel 2003 version.

Here is my situation:

1. I have a date of execution stated in Column D (e.g. 25/04/2011)

2. Deadline of submission of report is stated in Column E (e.g. 27/07/2011).

3. I need cells to change color based on column D, red for 90 days, orange for 60 days, yellow for 20 days and green for 10 days

4. This is so that I can track the progress of the submitted reports if they are not yet submitted on time.

I also tried using =NOW() but I can't figure it out much... I need the file to be updated every time I open it..

Please I need your help!

Thanks so much!