Highlight differences between two columns, a1 b1

[John Louis]

Hello, I have two columns each containing hundreds of rows, each cell in the rows contain several alphanumeric strings separated by a comma. What I would like to do is in the first column, column A cell 1 is have excel look at all the data in cell a1 and compare it againest the second column, column B cell 1 and have it highlight the unique (differences) in each cell. I also want to be able to apply this to all rows in each column. I tried conditional formatting but it doesn't like the alphanumeric strings I think. Thanks for any help you can provide I appreciate it. Thanks John

 

[MickG]

You're welcome

 

[John Louis]

Hi Mick, I should have asked you if my problem could be solved with any other excel tool. Not including VBA. Thank you

 

[MickG]

Unfortunately I shouldn't think so, but you never know someone might have a solution, you could try a new thread with No VBA criteria !!!

 

[John Louis]

Ok thanks Mick I will give that a try!!