# how to highlight duplicates in google sheets

Viewport: 1910x922 @1.125x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Highlight Duplicates in Google Sheets
   - body: Follow these steps to easily highlight duplicate values within your Google Sheets. This guide will help you identify and highlight any duplicates in a specific range of cells.
   - voiceover: This guide will take you through the steps to highlight duplicate entries in Google Sheets. Follow this easy step-by-step tutorial to make your data analysis more efficient.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omha6u00000cjl5gn66jes.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Open Google Sheets.
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (878.1335635950724, 257.9455094670058), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (878.1335635950724, 257.9455094670058), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Navigate to your Google Sheets application and open the spreadsheet you want to work on.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfw700020cjlgxxw2gjy.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8oluwg2000003hugk5f11lr.png
2. step_02 [image] - Select the Column/Range – Highlight the data where you want to find duplicates.

   - source type: IMAGE
   - description: Select Range
   - target: (711, 153), rect: top=141.7777862548828 left=46 width=1640 height=24
   - hotspots: 1
     - hotspot_01 (711, 153), rect: top=141.7777862548828 left=46 width=1640 height=24
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Highlight the data where you want to find duplicates by clicking and dragging over the cells you are interested in.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfww00030cjl3j3e3dmr.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8oluxcd000103hug3qkdmfn.png
3. step_03 [image] - Click on Format in the top menu.
   - source type: IMAGE
   - description: Navigate to 'Format'
   - target: (256.5395173829904, 78.56942696852533), rect: top=34 left=233.2916717529297 width=62.02777862548828 height=23.55555534362793
   - hotspots: 1
     - hotspot_01 (256.5395173829904, 78.56942696852533), rect: top=34 left=233.2916717529297 width=62.02777862548828 height=23.55555534362793
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Go to the top menu and click on the 'Format' option to open the formatting menu.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfxf00040cjlhgd59zzn.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8oluyv4000203hu3agemh5h.png
4. step_04 [image] - Navigate to Conditional formatting.
   - source type: IMAGE
   - description: Click on 'Conditional formatting'
   - target: (496, 444), rect: top=441.5555725097656 left=272.1805725097656 width=267 height=20
   - hotspots: 1
     - hotspot_01 (496, 444), rect: top=441.5555725097656 left=272.1805725097656 width=267 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Within the Format menu, select 'Conditional formatting'. This will open the Conditional format rules sidebar on the right.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfy100050cjl35dq523e.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olv3wf000303huf2gr7u63.png
5. step_05 [image] - Click on add rule.
   - source type: IMAGE
   - description: Set Rules
   - target: (1353.9648734752436, 223.9999850979553), rect: top=198.88888549804688 left=1361.77783203125 width=320 height=61
   - hotspots: 1
     - hotspot_01 (1353.9648734752436, 223.9999850979553), rect: top=198.88888549804688 left=1361.77783203125 width=320 height=61
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: In the Conditional format rules sidebar, click on 'Add another rule' to create a new formatting rule.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfyi00060cjlasvoef6n.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olv5vw000403hubr1crzlc.png
6. step_06 [image] - Set Custom Formula – In the Format rules, choose Custom formula.
   - source type: IMAGE
   - description: Choose Custom Formula
   - target: (1337.910393399121, 356.2970028830721), rect: top=347.6666564941406 left=1388.6666259765625 width=249.36111450195312 height=20
   - hotspots: 1
     - hotspot_01 (1337.910393399121, 356.2970028830721), rect: top=347.6666564941406 left=1388.6666259765625 width=249.36111450195312 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: In the Format rules section, choose 'Custom formula' from the dropdown menu to set a custom condition for formatting.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfz200070cjlhi3rai8p.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olv7f7000503hua9lit5sw.png
7. step_07 [image] - =COUNTIF(A:A, A1) > 1
   - source type: IMAGE
   - description: Choose Formatting Style
   - target: (1340.85587954427, 393.89103962688955), rect: top=384.6666564941406 left=1379.77783203125 width=179.55555725097656 height=36
   - hotspots: 1
     - hotspot_01 (1340.85587954427, 393.89103962688955), rect: top=384.6666564941406 left=1379.77783203125 width=179.55555725097656 height=36
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Enter the formula '=COUNTIF(A:A, A1) > 1' in the provided field. This formula checks if there are any duplicates in the selected range.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhfzq00080cjl912pa84f.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olvlgy000703husulwyqu9.png
8. step_08 [video] - Click here
   - source type: VIDEO
   - target: (1650, 586), rect: top=559.5555419921875 left=1578.5833740234375 width=85.19444274902344 height=36
   - hotspots: 1
     - hotspot_01 (1650, 586), rect: top=559.5555419921875 left=1578.5833740234375 width=85.19444274902344 height=36
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - clip: start=33.768 end=36.986 duration=3.2179999999999964
   - video: url=https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olurr500010cjr55pc6d4r.webm speed=1 muted=true
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olurr500010cjr55pc6d4r.webm
9. step_09 [image] - Duplicates are now highlighted! 🎉
   - source type: IMAGE
   - target: (888.4185232423819, 417.16341512438316), rect: top=121.8888931274414 left=1361.77783203125 width=320 height=660
   - hotspots: 1
     - hotspot_01 (888.4185232423819, 417.16341512438316), rect: top=121.8888931274414 left=1361.77783203125 width=320 height=660
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Once you input the formula, duplicates within the selected range will be automatically highlighted according to the chosen formatting style.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omhg0700090cjld6ijfsqc.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8olvqig000a03huddmvc3cy.png
11. [Outro] Duplicates Highlighted
   - body: Your duplicates should now be highlighted in the selected range. You can now proceed to review or edit these values as needed.
   - voiceover: Now that you have highlighted duplicates, you can proceed to further analyze or clean your data based on the highlighted entries.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8olurpp0001jr0cemjjsupf/cm8omheig00010cjl24y2dqkb.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm8olurpp0001jr0cemjjsupf/tour