I have a workbook with two sheets with two columns on each which need to be compared and highlight any duplicates on Sheet 2

Example:

Sheet 1

First Name Last Name
Joe Bloggs
Harry Houdini
Tony Stark
Batman Glooney

Sheet 2

First Name Last Name
Harry Houdini
Peter Pan
Joe Graham
Joe Bloggs