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.