I am trying to create a spreadsheet to track suspense dates for projects and
I am having difficulty trying to use conditional formatting in order to
complete my project.

1. I want to turn the cell green it is greater than 7 days before the
date entered into the cell.
2. I want to turn the cell yellow if it is within 7 days before the
date entered into the cell.
3. I want to turn the cell red if it is after the date entered into the
cell.



I want to use this in a spreadsheet used to track due dates (suspenses).
Another words, if my suspense is 1 July 2005, I want this suspense block to
be green if it is viewed on 23 Jun 2005 or earlier, yellow if it is viewed
between 24 Jun 2005 and 1 Jul 2005, and red if it viewed on 2 Jul 2005 or
after.



If anyone can help me out with this task, I would really appreciate it.
Thank you.

Joe