indicate identity between two fields

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.

=X1=Y1

will return TRUE if they are the same and FALSE if different - this
goes in row 1, drag down the column to autofill

W van Cothen wrote:
> 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.

<aidan.heritage@virgin.net> wrote in message
news:1150190499.452582.287610@f6g2000cwb.googlegroups.com...
> =X1=Y1
>
> will return TRUE if they are the same and FALSE if different - this
> goes in row 1, drag down the column to autofill
>
> W van Cothen wrote:
>> 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.
That helps a lot, thank you very much.