Hi,

Let's say that your data is set up like this in range A1:C4.

1 4 6
2 5 1
3 6 7
4 1 8

Now while in cell A1, go to Format Conditional formatting type the foll.
formula in "Formula is" =COUNTIF($B$1:$C$4,$A1)=1. Select the font color
desired.


--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ukiuki" wrote in message
...
How do I compare 3 columns? Need to know the data in all 3 columns are
the
same.