You can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Martina" wrote in message ...

Hi Macropod,
Thank you the TODAY function works fine. It does raise another question
though. What if I want to have another cell somewhere else on the sheet (say
A4) which looks at the cell with the expiry date in it (Z4) and if Z4 has
expired A4 will turn red also.

I have tried to make it happen, and it does but I get the date displayed in
A4 aswell. I only want the cell to turn red, I don't want any text in it.
I want it to be like an alert button to say that a date has expired in
another part of the sheet. Is this possible?

Can a cell in the sheet adopt the formatting settings of another cell in the
sheet without taking on the text/numeric entry?

regards
Martina