try conditional format

Select the column B as shown in your example
Go to Format on the Tool bar
Select Conditional Format
Under Contional 1, choose Formula Is
on the next box, type =A2=Today()
Click Format
Go to Patterns
Select the color
Click okok


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Tom" wrote:

Sounds simple, but I don't think it is.

Here is what I face:
Date Location
5/14/2009 A
5/14/2009 B
5/14/2009 B
5/14/2009 C
5/15/2009 A
5/15/2009 A
5/15/2009 B
5/15/2009 C

Based on today's date (Say 5/15/09) I want to highlight the cells that have
the same location. But only for today's date. When the date changes, they
are no longer highlighted and it moves on to a new day. Now I am working in
Excel 2003.
Can I get some hints or a clue here?

Thanks.