I have two columns A & B. I need to first check if the Value in Column
B exists in Column A if yes then Highlight the Value in Column A.

So...

Name1 Name2
Dude Harry
Joe Sally
Bob Joe

Result:
the cell with Joe in Name1(ColumnA) should be Highlighted.