conditional formatting
Select all the date cells, say B2:M32, and use a formula of
=B2<TODAY()
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Olaf" wrote in message
...
I have made a calendar and I would like to have the font color of the
dates
that are older than today change using conditional formatting.
How doI do this?
OLaf
|