Select B6:F66, with B6 as the active cell do formatconditional formatting

select cell value is equal to

and put

=TODAY()

in the box, select the formatting you want and click OK twice


--


Regards,


Peo Sjoblom



"Al Avery" <Al wrote in message
...
My worksheet has a number of columns. The second column is a sequence of
month-ending dates that are one month apart. The 5th column has a series
of
values. I want the 5th column's cell highlighted whose date in the
month-ending column includes to today's date.

Here's an example (hope it comes out clealy enough with proportional
font):

Row Col B ... Col F
No. Month Ending ... Value
---- -------------- ---------
32 08/24/2008 45,000
33 09/24/2008 45,250
34 10/24/2008 45,500

Since today's date is 09/20/2008, cell F33 should be highlighted.

The actual array is B6:F66, without headers.

Many thanks for any help,