Probably a simple one for you Excel wizzards.
Could someone explain me how I can, in an Excel, sheet automatically
indicate whether two values (actually letters A, B, C,D) are identical or
not? So I have column X with a long list of A's B's C's and D's (one per
field) and column Y with a similar but different list and I would like to
see where the diffrences are on the same row either by a symbol given in
column Z or for instance by a color assigned to the different or similar
values.
Thanks in advance.