conditional formatting
 

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

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

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

conditional formatting
 

thanks


"Frank Kabel" wrote in message
...
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