I think your formulae should be

yellow
=AND(G2<TODAY()+7,G2TODAY())

red
=G2=TODAY()

blue
=AND(G20,G2<TODAY())

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brockjr38" wrote in message
...
I was combing through previous correspondence and see that there are many
ways to condition a cell to change formating depending on a given date.
The
following was the best fit for my application:
one for 7 days before due date, =AND(G20,G2TODAY()-7,G2<TODAY())
Color change yellow
one for due date, =AND(G20,G2=TODAY())
Color change red
one for past due, =AND(G20,G2TODAY())
Color change blue
However, the condition entered for the past due date also effects any
future
due dates that I may forecast. How can I write a condition to distinguish
between a future due date and a past due date? Perhaps I need to chart
another direction? I am thankful for any help you can provide.