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?

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?