Hi Tom,

Try a conditional Format:

Select cell B2
Select the Format option from the main menu
Select Conditional Formating
Select Formula is in the first text box
In the second text box type the following formula: =and(a2=today(),b2=b1)
Click the Format button
Select whatever formats you wish to apply to the cell
Press the OK button twice.

This will not highlight both duplicates but one of them.

Please press YES if this helped

HTH
John

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