conditional formatting

  • Thread starter Thread starter Olaf
  • Start date Start date
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
 
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)
 
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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting with VBA 4
Excel conditional formatting with Weeknum 4
Conditional Formatting macro: simple, but doesn't work 6
Set Priority for Conditional Formatting in Excel 2003 2
recognizing conditional formatting with VBA 3
Excel 2007 Condition Formatting - Dates 1
change font using conditional formatting 1

Back
Top