Use CF formulae of

=AND(B1="",A1<TODAY()-7) 'red
=AND(B1="",A1<'TODAY()) 'yellow
=AND(B1="",A1TODAY()) 'green

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Oscar" wrote in message
...
Hi, I have a problem at work; I am trying to use conditional formatting to
highlight a date. If the date is between today and seven days ago
highlight
yellow, before that green and after that red. This is all set up easy,
the
problem is that I want it to reflect also when a date is entered in
another
cell, if the date is seven days overdue it will be red but if the receipt
date is entered in another cell with a date that is still in range of
another
color, I want the cell to reflect it.

I hope anybody can help me and if you need to see the spreadsheet just
email
me and I'll send it to you just in case I didn't make myself clear.

Thanks in advance for any replies.


Thanks in advance for any replyies.