Thread: Due Date Alert with Conditonal Formatting

I have excel 2007

I have two columns one is "from" Date and the other is "thru" Date. I need the "thru" column dates to be compared to todays date and
- colored Green if it is 90 days to being due
- colored yellow if it is 60 days to being due
- colored red if it is days to being due

How do I apply all there conditions to a coloumn with 100 plus dates?

use conditional formatting:
=A1=TODAY()-90===>FORMAT GREEN
=A1=TODAY()-60===>FORMAT YELLOW
=A1=TODAY()-30===>FORMAT RED

when i put the formula in do i highlight the whole column of dates or one at a time?

You should be able to select the whole column of dates, just make sure that you remove the $ signs from the references.

It's not working for me =(

I attatched the worksheet.. the column called "thru" is the one i need highlighted with the conditions.. what am i doing wrong?

Hi mate,

I have setup the sheet for you with my suggestion for a solution to your query.

For the color RED which were the dates expired compared to todays date I used the following code:

=AND(E1<>"",TODAY()>=E1)

The next rule you have to set up if the above rule couldn't be applied is the yellow color which were dates about to expire within 2 month (or 60 days). I used the following code:

=AND(E1<>"",TODAY()>=EDATE(E1,-2))

The last rule you wanted to have setup was the green color. Here you simply change the last mentioned code to -3 which is equal to 90 days.

Since the rules are applied in order you have to make sure the red is first, yellow 2nd etc.

Please also see my attachment.

Regards,

Kagesen