Thread: comparing two columns

Hi there i have the data as follows

Columns A B

Row 1 [ 1 2 3 4 ] [ 1 2 3 4 5 6 ]

Row 2 [ 5 6 7 ] [ 1 2 3 ]

Row 3 [ 10 11 12 13 15 ] [ 1 10 11 12 15 16]

i want to highlight the duplicate values and the coulmn c should indicate whether it has the duplicates or unique values in short i need the output as below where in first row numbers 1 2 3 and 4 will get highlighted as they are appearing in second column as well in second row none of the number gets higlighted and in third row 10 11 12 and 15 must get highlighted.

Columns A B C

Row 1 [ 1 2 3 4 ] [ 1 2 3 4 5 6 ] Duplicates

Row 2 [ 5 6 7 ] [ 1 2 3 ] Unique

Row 3 [ 10 11 12 13 15 ] [ 1 10 11 12 15 16] Duplicates

would really appreciate if any one provide a soultion to it