How to find non-repeating values in Column B for repeating values in Column A

I have a spreadsheet with 2 columns. Column A contains a list of names that may or may not repeat and Column B depicting favorite colors. If a value in Column A repeats, I want to select/highlight/identify/indicate all rows where the Column B values for that name are NOT the same.

Here's the table:

Name Color
John Blue
John Blue
John Blue
Harry Yellow
Peter Red
Peter Red
Peter Blue
Peter Green

In this table, I would like to select/highlight/identify/indicate all the PETER rows. Is this possible? I am using Excel 2013.

Thank you in advance.

Hi JeteMc

Thank you for your reply...it was very close!

It is highlighting HARRY's single row and only the first 3 rows for Peter. If I include more than 1 row for HARRY, and change the formula to "=COUNTIFS($A$2:$A$10,$A2)<>COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,$B2)", it works. There seems to be an issue if there's only a single row for a particular name, as is the case for HARRY.

Hi JeteMc

Got it to work. Fat-fingering on my part. Very slow, however, as the actual spreadsheet has 14 columns and 63,000 rows. Still, only 2 columns are being compared.

Thanks for your help!

Hi JeteMc

Even creating the Helper column is taking a lot of time to process because it's looking at the whole range for each row... =COUNTIFS($A$2:$A$63000,$A2)<>COUNTIFS($A$2:$A$63000,$A2,$B$2:$B$63000,$B2).

I REALLY appreciate your help with this. I do get the desired result, albeit while I take a coffee break :-), but it works. I'll work up another VBA forum version of the question at your suggestion.

Thanks again!