---
title: "How to highlight duplicate rows in Google Sheets with Google App Script"
author: "Martin Hawksey"
date: 2023-05-01T19:51:53+00:00
canonical_url: https://pulse.appsscript.info/p/2023/05/how-to-highlight-duplicate-rows-in-google-sheets-with-google-app-script/
markdown_url: https://pulse.appsscript.info/p/2023/05/how-to-highlight-duplicate-rows-in-google-sheets-with-google-app-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
tags:
  - "kcl.hashnode.dev"
featured_image: https://pulse.appsscript.info/files/2023/05/1SRrl70hpADi8zixiAVY2Zg.png
description: "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."
---

# How to highlight duplicate rows in Google Sheets with Google App Script

![How to highlight duplicate rows in Google Sheets with Google App Script](https://pulse.appsscript.info/files/2023/05/1SRrl70hpADi8zixiAVY2Zg.png)

> [https://nibeshkhadka.medium.com/how-to-highlight-duplicate-rows-in-google-sheets-9d17b0c75476](https://nibeshkhadka.medium.com/how-to-highlight-duplicate-rows-in-google-sheets-9d17b0c75476)
> 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.

Source: *[How to Highlight Duplicate Rows in Google Sheets?*](https://kcl.hashnode.dev/how-to-highlight-duplicate-rows-in-google-sheets)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/05/how-to-highlight-duplicate-rows-in-google-sheets-with-google-app-script/](https://pulse.appsscript.info/p/2023/05/how-to-highlight-duplicate-rows-in-google-sheets-with-google-app-script/)*