Hi John,

see the tips on this web page

http://www.j-walk.com/ss/excel/usertips/tip073.htm

Hope this helps
regards from Brazil
Marcelo




"John Michl" escreveu:

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