Conditional formattion with formula.
Say first list is in A1:A1000, Second list in B1:B500

Second list formula:
=COUNTIF(A1:A1000,B1)=0

First list formula:
=COUNTIF(B1:B500,A1)=0

HTH
--
AP

"John Michl" a écrit dans le message de news:
...
I have two lists of names. In the second list, I'd like highlight all
of the names that are new to the list. In the first list, I'd like to
highight all of the names on the first list but not the second.

Could this be done using conditional formatting without adding any
dummy or helper columns?

Thanks.

- John