conditional formatting

  • Thread starter Thread starter LNS
  • Start date Start date
L

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?
 
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
 
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
 
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?
 
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?
 
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.
 
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.
 
Yes, thanks it works.

T. Valko said:
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.
Click to expand...
 
Yes, thanks it works.

T. Valko said:
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.
Click to expand...
 
Back
Top