Hi can anyone tell me if there is a way to highlight or expose a cell in a column (B:B sheet1) if the value it contains does not appear in another column (A:A sheet 2) please?
my two columns are actually on different sheets if this makes a difference.
many thanks
Bookmarks