I so this post below which I'm going to use in the future and it works
perfectly but I can't do the cell highlighted. I am using Excel 2007.
Thankyou.


(Need help with a formula that will Count down the number of days before a
contract will expire. When the date is Expired, I need it to say "EXPIRED",
and highlight the cell. Can anyone help me with this?)