indicate identity between two fields

[W van Cothen]

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]

=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]

=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

That helps a lot, thank you very much.