Conditional Format ?

[Scottmk]

Hi
I have a cell that =today(). Then, I have a column of due dates fo
rows. I would like to set up a conditional format that turns the du
date cells green, yellow, or red if they are 3,2,or 1 week(s) out. An
ideas?
Thank

 

[Frank Kabel]

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

 

[Scottmk]

Thank you once again Frank.
Scot