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!
Bookmarks