Hi
try the following (assumption: A1 stores TODAY():
- select your due dates (e.g. cells C1:C100)
- goto 'Format - Conditional Format'
- enter the following formula
=(C1=$A$1-7)*(C1<$A$1+14)
for one week due
- choose a format and repeat for the other two conditions


--
Regards
Frank Kabel
Frankfurt, Germany

"Scottmk " schrieb im
Newsbeitrag ...
Hi
I have a cell that =today(). Then, I have a column of due dates for
rows. I would like to set up a conditional format that turns the due
date cells green, yellow, or red if they are 3,2,or 1 week(s) out.
Any
ideas?
Thanks


---
Message posted from http://www.ExcelForum.com/