Highlight Discrepancies
No, you can use CF with a formula of
=COUNTIF(B:B,A1)0
in column A
and
=COUNTIF(A:A,B1)0
in column B
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"PAL" wrote in message
...
Is there a way to highlight differences between to lists, but not change
them. Do you have to simply insert columns side by side and use
conditional
formating?
|