Compare cell contents

[Peter]

Hi,

I want to check if two cells do contain the same text, e.g. the same country name.

In case there is a difference I want to highlight the first cell with color red. something like
that.

I tried Conditional Formatting but it seems that the IF function only works for numbers, and not for
text.

If you do IF (A1=A2,.....) that does not work.

Anyone an idea how to compare text strings in Excell.

Thanks in advance

 

[Tieske]

When using a formula with conditional formatting, it can be any expression
as long as it returns either true or false.

In your case forget the IF and just try: =A1=A2

Tieske

 

[Paul B]

Peter, select A1, cond. format, cell value is not equal to click on A2,
format as you want

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003