How do I make an expiry date show-up in a different colour?

[Guest]

Hi there

I need to accentuate an expiry date in a different colour, how do I do that?
So I would like to put in a date and for excell to calculate the date a year
from that date and show me that in for example red. I hope yiu undertsand my
question.

Thanks, Renate

 

[Wayne Morgan]

If this question is for Excel, please try one of the Excel newsgroups. This
one is for the Access Database program.
Before you do that, if you want to change colours based on a value, check
the help file for Conditional Formatting.