How to find different value in excel and highlight the different

[hari2902]

VALUE 1	VALUE 2	COMPARE
C1, C2, C3, C4, C5, C6, C7, C8, C9, C10	C1, C2, C3, C4, C5, C6, C7, C8, C9, C10	TRUE​
C1, C2, C3, C4, C5, C6, C7, C8, C9, C10	C1, C2, C3, C4, C5, C66, C7, C8, C9, C10	FALSE​
Hope be like this below
C1, C2, C3, C4, C5, C6, C7, C8, C9, C10	C1, C2, C3, C4, C5, C66, C7, C8, C9, C10	FALSE​

 

[etaf]

EDIT

IGORE

I just see you want to highlight the text whee different
should have opened the image earlier

will need VBA for that - sorry - i cannot help

is this just the 2 rows you wan tto compare and then extract the one list to a new row

Or is the real data more involved

in C2 put
A2=B2
copy down to C3

 

[hari2902]

@etaf,

Thanks for your replay.

Yes, the simple formula is A2=B2,

But, i want to know how the formula, if need the result with highlight the different finding?