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,