Thread: compare the contents of one range of cells with the contents of a.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default compare the contents of one range of cells with the contents of a.
use conditional formatting as described at

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



"Dozy123" wrote:

I have two lists of names in two different excel spreadsheets. How can I
compare the lists to see if any names are on both?
Reply With QuoteReply With Quote