COMPARISION between two columns
Highlight the duplicate values between two columns using conditional formatting
=COUNTIF($A$1:$A$8,B1)>0
Download The Workbook