Conditional Formatting Non-Adjacent Columns

[Al Avery]

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,

 

[Peo Sjoblom]

Select B6:F66, with B6 as the active cell do format>conditional 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

 

[Peo Sjoblom]

Sorry, didn't notice that the dates are in B

Select F6:F66, but use formula is

=$B6=TODAY()


--


Regards,


Peo Sjoblom

 

[Al Avery]

Hum, didn't work for me. Using Excel 2007 and the example above, I:

Selected F6:F66

On the Home tab, selected Condition Formatting > Highlight Cell Rules >
Equal to...

In the Equal to window, entered =$B6=TODAY() in the "Format cells that are
EQUAL to" box

Chose formatting

Clicked Ok

No cell formatting in the range F6:F66 changed.

Even when I entered a specific cell in the date range,=$B$33 (in my
example), no formatting changed

Perhaps I'm doing something incorrectly.

- Al Avery