I don't think I understand. Can you give some examples? No attachments, just
spell it out.
--

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.