View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cesar Urquidi[_2_] Cesar Urquidi[_2_] is offline
external usenet poster
 
Posts: 11
Default How to highlight what's different between two columns

Hello,
I have two columns with alphanumeric data ("a" & "b").
The data in the cells is not necessarily in the same row all the time (may
or may not be aligned).
Sometimes one column is longer than the other.
Here's an example:

Column A Column B
10100A 10100A
10200A 10200A
10300A 10300A
10400A 10400A
10500A 10600A
10600A 10700A
10700A 10800A
10800A 10900B
10900A

Is there a way to highlight the cells that are different in the two columns???
Either by using a formula in column "c", or by using conditional formatting
by selecting the whole column from the top ("a" & "b")???

In this example these are the cells that need to be highlighted:

"10500A" (Because it is in "a", but not in "b").
"10900A" (Because it is in "a", but not in "b").
"10900B" (Because it is in "b", but not in "a").

Help please!!!

Thank you.