What you're looking for Conditional Formatting. Easier for you to do a quick
search of it in Excel's help than for me to explain it here. Basically,
you'll tell each of your cells to change their format if their value matches
the key value in another cell (e.g. where you're putting the date they need
to match).

"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.