conditional formatting

O

Olaf

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
 
B

Bob Phillips

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)
 
F

Frank Kabel

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)
 
O

Olaf

thanks


Frank Kabel said:
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)
Click to expand...
 
Top