Find duplicates in column pairs??

[squirrellydw]

Is there an easy way find duplicate names the show up in different columns? The tricky part is it would have to cover columns in pairs for example if John Doe is listed in column B and K, or C and L, or D and M, or E and N, or F and O, or G and P, or H and Q. I have it working now but I had to make a rule for each column? Just trying to find an easier / better way.

 

[Peter_SSs]

Thanks for the explanation.