HELLO,
Please I have a 2 lists in both sheet 1 and sheet 2 of the same documents (see attached).
These lists has the same names but one list (List 1) is more populated than the other.
What I want now is to color the names that appeared on list 1 just once but are not on list 2 since list 1 has the highest number of names.
Please help me out.
Thank you
Bookmarks