Select Conditional Formatting from the expanded menu. Open the Google Sheet containing your data and go to the Format menu. Here’s how you can find duplicates in Google Sheets: You can use Conditional Formatting in Google Sheets combined with the COUNTIF formula to quickly highlight cells that contain duplicate values. That said, the imported mailing list may sometimes have duplicate email addresses and it is thus be a good idea to clean up the data in your Google Sheet by removing duplicates before sending out the emails. You can then use Mail Merge or Document Studio to send personalized emails to your contacts from within the sheet itself. The Email Extractor app pulls emails addresses of your contacts from Gmail into a Google Sheet. The duplicate cells can be easily removed from the spreadsheet with Google Script. How to quickly highlight cells with duplicate values in Google Sheets using conditional formatting.
