Compare cell contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 29 Sep 2006 11:40 GMT

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

Reply to this Message

Tieske - 29 Sep 2006 11:47 GMT

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

> Hi,
>
[quoted text clipped - 12 lines]
>
> Thanks in advance

Reply to this Message

Paul B - 29 Sep 2006 11:48 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks in advance

Reply to this Message