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?