Conditional Formatting

[Pat]

I have a column (J) with due dates expanding to 2015. I would like the due
date to change color when:
1. Due date is within 15 day of today's date (Yellow).
2. Due date is pass today's date (Red)
3. Due date is out pass 365 days (No color)

Can this be done?

 

[FSt1]

hi
assuming that you due date is in A1, in A1.....
1.cell value is......less than.......=today()+15
2.cell value is..... less than......=today()
3. to me no color means no CF.

Regards
FSt1

 

[Pat]

I tried your suggestion and it didn't work. Is it because I have a formula
in J Column calculating the due date.

 

[FSt1]

hi
I tested. mine works with formulas. using 2003.
but i did notice something. redo the CF like this and see if that helps....
1.cell value is......less than.......=today().............red
2.cell value is..... less than.......=today()+15.......yellow

regards
FSt1

 

[FSt1]

hi again
i am assuming that you did know to adjust the range to column J. in my first
post, i assumed your dates were in column A and told you to put the CF in A.
if you did put the CF in A, move it to J.
just making sure.

regards
FSt1

 

[Pat]

Dates that are over 365 days are turning yellow. Thank you for your help.