Hello All,

Don't know why this one has stumped me, but I can't get it right and keep getting the N/A error.

I have a row of cells on sheet one that have different values (item numbers) in Column A. Can be as few as 15, as many as 500. I have a second sheet on the same workbook that has another list of numbers (random order).

I'm trying to conditionally format the cells on sheet 1 to highlight if that specific number appears anywhere in the range on sheet 2 (to find duplicates). I can't seem to get this right.

Thank you!