View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SarahJ SarahJ is offline
external usenet poster
 
Posts: 6
Default Compare and Highlight

I need help figuring out how to do the following.

I have 2 work books "Book1" and "Book2"
Columns A & B of Sheet1 in both workbooks contain First Names and Last Names.

I want to compare the workbooks and if the name in Book1 appears in Book2 I
want it highlighted in Book1.

Is this possible?