Gary''s Student said:
Use Conditional Formatting
....
OK if all OP wants to do is look at the non-common values. OTOH, if
the OP wants to use the non-common values, better to use filters. If
one list were in AA3:AA1000 and the other in BB3:BB2000 and columns AB
and BC were blank, enter these formulas:
AB3: =ISNA(MATCH(AA3,$BB$3:$BB$2000,0)) and fill AB3 down into
AB4:AB1000
BC3: =ISNA(MATCH(BB3,$AA$3:$AA$1000,0)) and fill BC3 down into
BB4:BB2000
Then filter AA2:AB1000 on column AB: FALSE filters entries in column
AA which aren't column BB. Similarly, filter BB2:BC2000 on column BC.