{"id":50259,"date":"2024-08-06T16:12:46","date_gmt":"2024-08-06T14:12:46","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=50259"},"modified":"2026-01-07T18:57:09","modified_gmt":"2026-01-07T17:57:09","slug":"mettre-en-evidence-les-doublons-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-formulas\/highlight-duplicates-in-google-sheets\/","title":{"rendered":"Comment mettre en \u00e9vidence les doublons dans Google Sheets (2026 Tutoriel)"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">You are reading this post because you are probably tired of searching for duplicates in your <\/span><a href=\"https:\/\/www.sheetgo.com\/products\/for-google-sheets\/\"><span style=\"font-weight: 400;\">Google Sheets<\/span><\/a><span style=\"font-weight: 400;\">. Finding these duplicates is like searching for a needle in a haystack, especially if there are 100+ rows.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In this article, we will share a quick way to highlight duplicates in Google Sheets, and share formulas and pro tips. Keep reading!<\/span><\/p>\n<p><b>Key Takeaways:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To highlight duplicates in Google Sheets, select the range &gt; click Format &gt; Conditional Formating &gt; Format Rules &gt; Custom Formula Is. Enter the formula =COUNTIF(A:A, A1) &gt; 1 and click Done.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">=COUNTIF(A:A, A1)&gt;1 is the formula to highlight duplicates in Google Sheets. Replace the letter A with the corresponding column.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">=COUNTIFS($B$1:$B,$B1,$C$1:$C,$C1) is the formula for highlighting duplicates in two columns. You can edit it to affect more columns.<\/span><\/li>\n<\/ul>[\/et_pb_text][et_pb_text module_id=&#8221;highlight&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2><span style=\"font-weight: 400;\"><b>How to Highlight Duplicates in Google Sheets<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">To highlight duplicates in Google Sheets, you need to set \u201cConditional Formatting\u201d and use the formula \u201c=COUNTIF(A:A, A1) &gt; 1\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Imagine you&#8217;re reviewing your inventory to identify the most popular products.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Your inventory list contains multiple entries for the same product, but they might be scattered throughout the sheet. Manually scanning the &#8220;Product Name&#8221; column would be inefficient and prone to errors, especially if your inventory is large.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s see how to highlight duplicates using the formula mentioned above.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">1. Select the entire &#8220;Product Name&#8221; column (Column B in our example).<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_1.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_1&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">2. Go to the &#8220;Format&#8221; menu and select &#8220;Conditional formatting.&#8221;<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_2.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_2&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">A sidebar will appear on the right.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_3.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_3&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">3. In the sidebar, under &#8220;Format rules,&#8221; choose &#8220;Custom formula is.&#8221;<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_4.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">4. Enter the following formula in the text box: \u201c=COUNTIF(B:B, B1) &gt; 1\u201d and click \u201cDone.\u201d<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_5.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_5&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">=COUNTIF(B:B, B1) looks at each cell in column B (Product Name). It then counts the number of times a product name appears in the whole column. &gt; 1 means that if a product name appears more than once, it should be highlighted.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Our inventory example shows that \u201cLaptop Pro\u201d and \u201cWireless Headphones\u201d appear more than once.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you want to check column A, change the B in the formula to A. The new formula will be =COUNTIF(A:A, A1) &gt; 1, and column C will be =COUNTIF(C:C, C1) &gt; 1. Remember to select the matching range or column: A column for the A formula and C column for the C formula.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_6.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_6&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">If you only want to highlight duplicates that appear more than ten times, change the number 1 to 10 at the end of the formula. The new formula will be: =COUNTIF(B:B, B1) &gt; <\/span><b>10<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Want to learn more about formulas? Check our list of <\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/100-functions-formulas-for-google-sheets-excel-basics\/\"><span style=\"font-weight: 400;\">100+ Google Sheets and Excel formulas<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The screenshot below shows a new scenario; \u201cLaptop Pro\u201d was highlighted because it appears more than ten times.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_7.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_7&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">Check out our complete guide on <\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/countifs-in-google-sheets\/\"><span style=\"font-weight: 400;\">how to use COUNTIF in Google Sheets<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>[\/et_pb_text][et_pb_text module_id=&#8221;multiple&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2><b>How to Highlight Duplicates in Multiple Columns<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Assume you want to know if you&#8217;ve bought a specific product from the same supplier more than once. This will help you identify your most frequent partners and negotiate better deals. In this case, you need to count the events where BOTH the &#8220;Product Name&#8221; AND the &#8220;Supplier&#8221; columns match.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">So, let\u2019s see how to highlight duplicates in multiple columns using \u201cconditional formatting\u201d and \u201cabsolute values.\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">1. Select the entire table or the needed columns. In our case, we will select the &#8220;Product Name&#8221; and &#8220;Supplier&#8221; columns (columns B and C).<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_8.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_8&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">2. Go to the &#8220;Format&#8221; menu and select &#8220;Conditional formatting.&#8221;<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_9.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_9&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">3. Under &#8220;Format rules,&#8221; choose &#8220;Custom formula is.&#8221;<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_10.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_10&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">4. Enter the following formula: =COUNTIFS($B$1:$B,$B1,$C$1:$C,$C1) &gt; 1<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_11.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_11&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">=COUNTIFS($B$1:$B,$B1,$C$1:$C,$C1) looks at each cell in column B (Product Name) and column C (Supplier). It then counts the number of times columns B and C match. &gt; 1 means B and C match more than once, it should be highlighted. The dollar signs ($) in the formula create absolute references. It ensures the formula works even when copied to other cells.<\/span><\/p>[\/et_pb_text][et_pb_text module_id=&#8221;remove&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2><b>How to Remove Duplicates in Google Sheets?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Follow the steps below to remove duplicates in Google Sheets:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">1. Select the range or entire sheet containing the data.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_12.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_12&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">2. Go to Data &gt; Data cleanup &gt; Remove duplicates.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_13.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_13&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">3. Choose whether your data has headers. In our case, we will check \u201cData has header now\u201d since there is a header called \u201cProduct Name.\u201d<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_14.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_14&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">4. Select the columns you want to check for duplicates.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_15.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_15&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">5. Click &#8220;Remove duplicates.&#8221;<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_16.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_16&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">A popup will appear and indicate the number of rows removed.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_17.webp&#8221; title_text=&#8221;how-to-highlight-duplicates_17&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">The downside is this method removes entire rows, not individual cells.<\/span><\/p>[\/et_pb_text][et_pb_text module_id=&#8221;edit&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2><b>Edit, Add, or Delete a Conditional Formatting Rule<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Follow the steps below to edit, add, or delete a conditional formatting rule.<\/span><\/p>\n<p>1. Select the range with the conditional formatting you want to edit.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_18.webp&#8221; alt=&#8221;highlight duplicates with conditional formatting 1&#8243; title_text=&#8221;how-to-highlight-duplicates_18&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">2. Go to the &#8220;Format&#8221; menu and select &#8220;Conditional formatting.&#8221;<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_19.webp&#8221; alt=&#8221;highlight duplicates with conditional formatting 2&#8243; title_text=&#8221;how-to-highlight-duplicates_19&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">3. The sidebar will open and show the existing formatting rules for the selected range. Click on the rule you want to edit.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_20.webp&#8221; alt=&#8221;highlight duplicates with conditional formatting 3&#8243; title_text=&#8221;how-to-highlight-duplicates_3&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">4. Update the format rules, formula, formatting style, or range as needed. Click &#8220;Done&#8221; to save the changes.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_21.webp&#8221; alt=&#8221;highlight duplicates with conditional formatting 4&#8243; title_text=&#8221;how-to-highlight-duplicates_21&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">To add a new conditional formatting rule, follow steps 1-2 and click \u201cAdd another rule.\u201d<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_22.webp&#8221; alt=&#8221;highlight duplicates with conditional formatting 5&#8243; title_text=&#8221;how-to-highlight-duplicates_22&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span style=\"font-weight: 400;\">To delete a conditional formatting rule, follow steps 1-2, hover your mouse over the rule, and click on the trash can icon next to it.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/how-to-highlight-duplicates_23.webp&#8221; alt=&#8221;highlight duplicates with conditional formatting 6&#8243; title_text=&#8221;how-to-highlight-duplicates_23&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><b>Rule Order Pro Tip:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">If you have multiple rules for the same range, their order matters. Rules are evaluated from top to bottom, and the first rule that applies to a cell determines its formatting. You can reorder rules by clicking and dragging them in the sidebar.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If the formatting applied by a higher rule covers the conditions of a lower rule, the lower rule might be overridden or might not appear at all.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2><b>FAQ<\/b><\/h2>\n<p><b>Can I highlight duplicates in Google Sheets?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Yes, you can easily highlight duplicates in Google Sheets using conditional formatting.<\/span><\/p>\n<p><b>What is the formula to highlight duplicates in Google Sheets?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The formula to highlight duplicates is: =COUNTIF(A:A, A1)&gt;1. Use this formula if the range is A and change A to B if the range is B. You can use the formula in Conditional Formatting.<\/span><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>You are reading this post because you are probably tired of searching for duplicates in your Google Sheets. Finding these duplicates is like searching for a needle in a haystack, especially if there are 100+ rows. In this article, we will share a quick way to highlight duplicates in Google Sheets, and share formulas and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-50259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/50259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=50259"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/50259\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=50259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=50259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=50259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}