View Single Post
  #1   Report Post  
lalexis lalexis is offline
Junior Member
 
Posts: 1
Default Highlighting duplicates on different sheets

Trying to find duplicates in columns on two different spreadsheets, and highlight them as yellow.

One file is "LeadShare" and the reference area is F2:F27

The other is "Install Customer List Pac NW- Diaz" and the reference area is G4:G745

I want the values on the Install Customer list to show as yellow fill if they are already stated on the first (Leadshare) list. Any help is greatly appreciated!