Hello,
Hope someone can help.
I have a list in column C and what i wanted was any entry with duplicated "rec" can be coloured red.
Example in list rec 09871 is in the list twice so the second one on row 11
should turn red so it stands out and can be picked up.
Please see attached.Thanks for any help.
Bookmarks