Hello All.

Can you please advise how to apply a conditional formatting to highlight the items in Sheet1 that match or are similar to Sheet2. thank you in advance for your support. I am having issues attaching an excel workbook and just added the data in sheet1 and sheet2 below.

Sheet1
BURT, JAMES (28)
MYERS, RICK (01)
EBERHARD, TIM (90)
MEADOWS, BEN (38)
MORG, DAN (55)
RIVERA, JOE (73)
DEHA, JOSH (11)
BURT, JAMES (18)
MYERS, DERICK (01)
EBERHARD, RON (30)
MEADOWS, BEN (38)
DEHA, JOSH
EBERHARD, TIM

Sheet2
BURT, JAMES
MYERS RICK
EBERHARD, TIM
MEADOWS, BEN
MORG, DAN
RIVERA, JOE
DEHA, JOSH