conditional formating dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(G2>0,G2>TODAY()-7,G2<TODAY())
Color change yellow
one for due date, =AND(G2>0,G2=TODAY())
Color change red
one for past due, =AND(G2>0,G2>TODAY())
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.
 
I think your formulae should be

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

red
=G2=TODAY()

blue
=AND(G2>0,G2<TODAY())

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top