I've searched and cannot quite find what I am trying to do (though it's probably extremely easy). I can highlight a single column no problem but I need to highlight names within a column based on both the name and a number on the cell adjacent to each name.

I have a column with names in it and an adjacent column with numbers in it and I'm trying to highlight duplicates that have the same name and the same number on a row. So say there are three Brian's in the name column and ajdacent to the Brian's only two numbers are the same, I only want these two Brian's to be highlighted (as below).

Tom 12
Brian 18
Mary 11
Joe 16
Anne 15
Tom 14
Brian 14 <--- so this one would not be highlited as the name and number don't match
Mary 12
Joe 13
Anne 19
Tom 15
Brian 18
Mary 17
Joe 12
Anne 13

I'm using Excel 2010 - could anyone help me figure this out? Thanks for any help!