conditional formatting
Hi Olaf
- select the cells (assume you start with A1 as upper left cell)
- goto the conditional format dialog and enter the formula
=A1<TODAY()
- apply your format (change A1 if required to the upper left cell of
your selection)
--
Regards
Frank Kabel
Frankfurt, Germany
Olaf wrote:
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
|