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.