Note that using this method highlights all the instances of the duplicate cell. Google Sheets is now highlighting duplicates in our grocery list. In the case of our example, weвЂ™re using the formula вЂњ =countif($A$2:$A$15,A2)>1вЂќ to check for duplicates. Set вЂњFormat cells ifвЂ¦вЂќ to вЂњCustom formula isвЂќ and enter the duplicate check formula вЂњ=countif(Range,Criteria)>1вЂќ and hit вЂњDoneвЂќ to return a вЂњtrue/falseвЂќ response.In case you already have conditional formatting applied, this option will be at the bottom (below the existing rule). Click on the вЂњ+ Add another ruleвЂќ option in the conditional formatting pane that opens.Open the conditional formatting window by opening the вЂњFormatвЂќ drop menu and choosing вЂњConditional formattingвЂќ from the list.In the example case, we want to use A2:A15 (image 1, box). To highlight duplicates cells with conditional formatting, follow these steps. Suppose you have a dataset as shown below and you want to highlight all the duplicate values in column A. Highlight Duplicates in Google Sheets (in a Single Column) You May Also Like the Following Tutorials:.Create a Unique Cells List (Instead of higlighting duplicates).Some tips when highlighting duplicates in Google Sheets.Highlight Duplicates with Added criteria.Highlighting and Find Duplicates in Google Sheets.Highlight Duplicates in Google Sheets (in a Single Column).

Find duplicates in excel