I have data in 2 columns ("B" and "D") and I want to report off of the outliers. Column B has a name, "Michael" and Column D has a number.
I want to be able to tell when a name has more than 1 color in the corresponding column. for eaxample:

Michael 11002
Michael 11002
Michael 11173
Carl 55689
Carl 55689
Dana 33749
Dana 33529

michael and Dana have disrepencies, so I want to highlight them. What is the best way to do this? I am well versed in Access VBA, but Excel, I am a bit lost. I do not want to have to do this via a pivot chart, perhaps an array? I am open to suggestions.