conditional formatting

[LNS]

How do I apply conditonally formatting to two rows which contain text? For
instance;

A B
1 Australia Australia
2 New Zealand Canada
3 Canada New Zealand

Is there anyway this is possible? Since row 2 shows that New Zealand is not
matching to Canada as in the first row so it highlights New Zealand in a
different color?

 

[T. Valko]

What version of Excel are you using?

 

[LNS]

2003

What version of Excel are you using?

 

[T. Valko]

Ok...

Let's assume you want to format the range A1:A10.

Select the range A1:A10
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1<>B1
Click the Format button
Select the desired style(s)
OK out

 

[LNS]

which means that i can only apply conditional formatting to each cell, that
is one by one? is there any way where i can apply it to the whole range?

 

[T. Valko]

If you followed my suggestion you are applying it to the whole range.

If you did follow my suggestion select cell A9. Goto the menu
Format>Conditional Formatting. Note the formula, it applies to cell A9.

 

[LNS]

Yes, thanks it works.

If you followed my suggestion you are applying it to the whole range.

If you did follow my suggestion select cell A9. Goto the menu
Format>Conditional Formatting. Note the formula, it applies to cell A9.

 

[T. Valko]

Good deal. Thanks for the feedback!