Highlight Duplicate Rows in spreadsheets efficiently and accurately with Google Apps Script for coders and non-coders.
Some nice techniques in this post which shows you how you can highlight duplicate rows in a Google Sheet using Google Apps Script. If you need to modify there is a
isDuplicateRow() which could be modified to suit your needs. Another nice solution in this example is the inclusion of function to
getRandomUniqueColor(), which returns a random hex colour.