View Single Post
  #1   Report Post  
Ellen
 
Posts: n/a
Default compare info in 4 worksheets and highlight fields that are the sam

I have someone who has 4 Excel spreadsheets with info in different columns.
Is there a way to have Excel compare all columns he chooses and highlight or
somehow indicate the fields that are the same in multiple
columns/worksheets?