View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Olaf Olaf is offline
external usenet poster
 
Posts: 2
Default 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