Compare two rows and find data that are different

[next2sin]

Hello everyone,

I have a set of User names one comes from an distribution list, and the other from active users list. What I am trying to accomplish is I want to search the entire column and compare it to the other column, and any information that does not match in any of the two (no matter what row it may be in) be shown whether it be highlighted or placed in a different column. Thanks in advance.

[FDibbins]

You can probably do this with Conditional Formatting. Assuming you have something like this...

	A	B
1	aa	bb
2	bb	dd
3	cc	ff
4	ee	hh
5	dd	jj
6	ff
7	gg

1. highlight the range you want to apply the conditional formatting to (A1:A7)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =match(A1,$B$1:$B$5,0) format FILL as needed

1. highlight the range you want to apply the conditional formatting to (B1:B5)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =match(B1,$A$1:$A$7,0) format FILL as needed

[next2sin]

I might be missing something in the steps because its not really doing anything. This might be a rhetorical question but is the "format FILL as needed" part of the code, or are you just telling me to format the fill if it finds differences? Regardless i tried both and it does not do anything. I appreciate your help.

[FDibbins]

Sorry you could not get this to work.

Did you follow my steps exactly (Im sure you did lol)
The "format FILL as needed" is the formatting - text color/background color/font/etc" that you would apply to highlight the matches

My sampl was very basic, you would need to adjust the ranges and references to suite your own data. If you uopload a clean sample workbook here, I can see whatr we need to do to get this working for you

[next2sin]

So just to reiterate, what I want is to check the whole list in both columns and any information that is not in both be highlighted.
The list is much bigger like a few hundred more lol this is just an example I made i wouldn't bother for such a small list.