conditional formating dates

B

Brockjr38

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top