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" wrote:

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?
--
pls