Highlight Sheets Duplicate With Color Highlighting How the repeats are displayed is fully customizable in the formatting style options. In Google Sheets, this same pop-up does not occur. SELECT THE DATA [ WHERE WE WANT TO HIGHLIGHT THE DUPLICATES] STEP 2: Go to FORMAT MENU> Conditional Formatting . Steps. Highlighting duplicates in Google Sheets can be done in multiple ways. Highlight Duplicates in Google Sheets You can use Conditional Formatting in Google Sheets combined with the COUNTIF formula to quickly highlight cells that contain duplicate values. Open the Sheets document you wish to sort. Press Enter to complete the formula. Final Thoughts Dealing with duplicate data in Google Sheets can be tricky; however, by using the functions listed above or an add-on like Power Tools, finding, analyzing, and removing duplicate data is quick and easy to do. But what if the names are in multiple columns (as shown below). How to Highlight Duplicates on Google Sheets on Android. Things to Remember about Excel Highlight Duplicate Values. Let's compare two columns in Google Sheets for matches and colour only those cells in column A that tally with cells in the same row in column C: Select the range with records to color (A2:A10 for me). To highlight duplicates across sheet tabs that within one Google Sheets file, as mentioned above, you must use the function Indirect and multiple Countif formulas. Also, there is a dedicated in-built add-on that helps to remove duplicate data in Sheets. Google Sheets: How to highlight duplicates in a single column. You can use Conditional Formatting in Google Sheets combined with the COUNTIF formula to quickly highlight cells that contain duplicate values. Follow these steps to remove duplicates from your sheet with the Remove Duplicates tool: Open your Google Sheet. Step 3. In the options that show up, click on Conditional formatting. With a little bit of conditional formatting, you can easily highlight duplicates in Google Sheets. Open your spreadsheet in Google Sheets and select multiple columns. To get rid of this, you can use the TRIM function (and the CLEAN function) to get rid of all the extra space characters. This is done using the following as the criteria: This now has been converted into a simple column type construct where the COUNTIF function checks how many times this combined string repeats in the array of string we created. Below are the steps to highlight duplicates in a column: The above steps would highlight all the cells with duplicate names in the specified color. Users may not simply want to delete this data, which Sheets natively supports, and instead analyze and work with it. STEPS TO HIGHLIGHT DUPLICATES IN GOOGLE SHEETS. Select the column you want to find duplicates in by clicking the letter at the top of the column. Suppose you have a dataset as shown below and you want to highlight all the duplicate records. Other Google Sheets tutorials you may like: Save my name, email, and website in this browser for the next time I comment. So check the references to make sure Google Sheets highlights the duplicates as expected. When you’re working with data in a spreadsheet, there are often duplicate values that need to be considered. Click into an open cell in the same sheet (for example, the next empty column in the sheet). Let’s see how all that formulas develop. When you use the custom formula in Conditional formatting, it checks each cell using the specified formula. Finding duplicates in columns let you examine a single column of data to see if there is anything in that column that has been duplicated. This can be used to represent specific reasons for why a duplicate was highlighted so it makes sense to anyone looking at the data. This will open the Conditional format … Below are the steps to highlight duplicates in multiple columns: The above steps would highlight the cell if the name appears more than once in all the three selected columns combined. Highlight the column you want to search through. In this tutorial, I will show you some simple ways to highlight duplicates in Google Sheets. To do this, click the text color icon (the A in the menu bar) and choose your color. For instance, you can highlight the entire […] 2. If the formula returns TRUE for the cell, it is highlighted in the specified format, and if it returns FALSE, it’s not. This one works the same way as our first example (where we simply highlighted the cells in a column that had duplicates). This array is used in the Countif formula, and the condition used is again a concatenated string that has all the values in a row. In this example, we've chosen red. A new field appears below it. STEP 2: CLICK CONDITIONAL FORMATTING … Again if number is not available on Sheet 2 then It wont highlight. Google Sheets will display how many duplicate rows were removed, as well as how many unique rows remain (Figure C). The steps to use this add-on are as follows: 1. Open the Google Sheets document in which you want to remove the duplicates Click the ‘Add-ons’ tab Click on ‘Get add-ons’ In the Add-ons dialog box that opens, search for ‘Remove Duplicate’ in the field in the top-right In case it isn’t, you can change it from the ‘Apply to range’ section, Click on the ‘Format cells if’ drop-down and then click on the ‘Custom formula is’ option. Make sure the spreadsheet has data organized by columns and each column has a heading. Select the area within the sheet you wish to remove duplicates from. I have mentioned a few tricks to highlight and get rid of similar information from the Google Sheet. You could also change the text color in the duplicate cells instead of filling it with a color. Here’s how you can find duplicates in Google Sheets: Open the Google Sheet containing your data and go to the Format menu. So these are the ways you can highlight duplicates in Google Sheets using conditional formatting. The add-on will look for the first entries of duplicated data in addition to unique records: You can return to step 1 by clicking … Tap the letter at the top of the column. Here are some possible reasons that you can check for: Are there any extra spaces (leading or trailing space characters) in the text in one cell and not the other? In the next step, we’ll be highlighting the cells that we want to segregate. Highlight Duplicates in a Single Column in Google Sheets Highlight All the Duplicates in a Column. These methods can help one to fix the issues related to the duplicates in google sheets. Select Conditional Formatting from the expanded menu. As I mentioned earlier, when you use conditional formatting to highlight duplicates in Google Sheets, it will highlight all the instances of duplicate cells. People commonly use this to find and remove repetitive information. You can also use a Google add-on to find and highlight duplicates in Google Sheets. Google Sheets can be used to highlight duplicates in a spreadsheet. Using the above option, you can easily remove duplicate entries in Google Sheets. Using Remove Duplicate Add-On. Posted on June 23, 2017 | by Prolific Oaktree. Follow these steps: Open the spreadsheet in Google Sheets then select a column. You can also use a formula to find the duplicate data in your spreadsheets. There is a function that is native to Sheets. Just in case if you want to highlight duplicates across multiple columns and rows, follow these steps. You have to check the entire row and only highlight those rows where all the cells repeat. Get the Latest Tech News Delivered Every Day, Lifewire uses cookies to provide you with a great user experience. The reason this is a bit tricky is that you don’t have to check individual cells now. How to Highlight Duplicates in Google Sheets (Step-by-Step), Highlight Duplicate Cells in Multiple Columns, Google Sheets Not Highlighting Duplicates – Possible Reasons, Apply Conditional Formatting based on Another Cell Value in Google Sheets, How To Remove Duplicates In Google Sheets, How to Count Cells with Specific Text In Google Sheets, How to Compare Two Columns in Google Sheets (for Matches & Differences), How to Find Unique Values in Google Sheets, How to Highlight Highest or Lowest Value in Google Sheets, Select the names dataset (excluding the headers), In the options that show up, click on Conditional formatting. https://www.lifewire.com/highlight-duplicates-in-google-sheets-4693470 In the above example, each cell is checked and if the name appears more than once in range, it returns TRUE for the COUNTIF formula, and the cell gets highlighted. Click Done to apply the conditional formatting. First, highlight the column or row that you want to evaluate. Each of described two methods below will let you deal with the duplication of data in a google sheet in cells. Highlight Duplicates Instances Only. Other methods: Use the UNIQUE formula or an add-on. After you're done highlighting duplicate entries in your spreadsheet, the next step is to delete them. In the COUNTIF formula, we have covered all the cells in the three columns. Below are the steps to highlight duplicate rows using conditional formatting: The above steps would highlight all the records that are repeated in the dataset (as shown below). These will be the cells that will have duplicates highlighted. Open Google Sheets in your internet browser. One way to identify duplicates is to highlight them with color. This is really crucial, as it makes sure that the range remains the same while conditional formatting is checking for the count of the name in a cell. Google Sheets | Highlight Duplicate Data in a Column or Row. But to make the maximum out from this built-in conditional formatting, you should know how to use custom formulas in it. Follow these means. But what if you want to highlight only the duplicate instances (and not the first time it appears in the list). Your formula will look something like this: Type the closing parenthesis in the formula cell (or press Enter) to complete the formula. This is really crucial, as it makes sure that when the formula goes to the next cell (in the row below), the overall range that is being checked for the name count remains the same. 2. STEP 1: Select the column or all the cells in which we want to highlight the duplicate items. 1. The first method we’re going to look at uses the built-in Google Sheets function that finds all unique entries, letting you get rid of everything else in the data set. Else, it remains unchanged. Final Thoughts Dealing with duplicate data in Google Sheets can be tricky; however, by using the functions listed above or an add-on like Power Tools, finding, analyzing, and removing duplicate data is quick and easy to do. If a formula calls for one type of reference and you end up using the others, you will likely end up with an issue. 2. Click the spreadsheet you want to edit. This process differs in two ways: Every option I have mentioned is free to use. For example, select section A > Format > Conditional designing. This method can work by column or by row and displays the duplicate data in a new column or sheet within your file. When working with data in Google Sheets, sooner or later, you will come across the issues of duplicate data. Every option I have mentioned is free to use. In this case, a record will be a duplicate if it has the exact same value in each cell in the row (such as row 2 and 7 in the above example). There are three different kinds of references in Google Sheets. Under Format rules, open the drop-down rundown and select Custom recipe is. This makes it easier to find duplicates when the duplicated cell isn’t on the screen. Next, click the empty cell where you want the data to output, type =UNIQUE, and then click on the suggested function that appears in the dialog window. So If I add that number in sheet 1 It will get highlighted since it is exists on Sheet 1. All duplicates should now have a red-filled cell. There is a function that is native to Sheets. In the Format cells if drop-down menu, select Custom formula is. ... Once highlighted, right-click and select Conditional formatting. Google sheets have different ways through which one can identify, compare and then remove duplicate entries. Open your accounting page in Google Sheets and select a segment. To eliminate duplicates the best option is using formulas. Once you have these highlighted, you can decide whether to keep them or delete them. Remove Duplicates from Google Sheets Using the Built-In Feature. Home » How to Highlight Duplicates in Google Sheets (Step-by-Step), Watch Video – Highlight Duplicates in Google Sheets. You can highlight single cells in a column, highlight the rows of those columns, and even highlight the duplicates without highlighting the first instance. Highlight Duplicates in Google Sheets. So, let’s get started with the ways one can find duplicates in Google sheets and step by step procedure also along with the screen shots provided. 3. After highlighting a cell, click on an empty cell at the top of an empty column to make sure that your information is moved to the side of the chart. The most common situation is when you have a dataset in a column and you want to quickly want to highlight the duplicates. This wikiHow teaches you how to find duplicate cells in a column using Google Sheets on your Android. The efficient way to identify duplicates in Google Sheets is by highlighting cells using the conditional formatting feature which is built-in. … Select the rows you wish to analyze for duplicates. Step 2: Highlight the cells you want to filter out. Follow these steps to remove duplicates from your sheet with the Remove Duplicates tool: Open your Google Sheet. When you’re done, hit Enter… The Conditional Formatting menu opens on the right. By using Lifewire, you accept our, How to Find Duplicates in Google Sheets Columns, Find Duplicates in Google Sheets With Formulas, Find Duplicates in Columns With a Formula, Find Duplicates in Google Sheets With an Add-On, How to Use Conditional Formatting in Google Sheets, How to Multiply Numbers in Google Spreadsheets, How to Remove Duplicates in Google Sheets, How to Use Google Sheets to Reference Data From Another Sheet, How to Sum Columns or Rows in Google Sheets, How to Sort Your Related Data in Excel With Tables, How to Use the Google Sheets If( ) Function, How to Use Custom Conditional Formatting Rules for Dates in Excel, How to Create a Gantt Chart in Google Sheets. After highlighting duplicate values, if you are deleting those records then be extra cautious as it will impact your entire dataset. Each of described two methods below will let you deal with the duplication of data in a google sheet in cells. Since we are looking for an exact match for two or more cells to be considered duplicates, if there are any extra space characters in the cells, this would lead to mismatch. In that empty cell, enter the following and then press Enter. The built-in feature offers the basic functionality of removing duplicate cells. This could be duplicate data in the same column or duplicate rows in a dataset. Highlight duplicates in two sheets or columns. If you want to highlight duplicates from a single column in Google Sheets, you’ll need to first select the column where you want to find duplicates. This tutorial will show you how to highlight the repeated items in a few easy steps. To do so, highlight the data you'd like to include, and click Data > Remove duplicates. Here the first, second, third… instances of any duplicate value will be highlighted. Any number from Sheet 2 to Sheet 1 Should Highlight in color. Enter the following formula in the new field, adjusting the letters for the column range you selected: In the Formatting style section, choose a fill color for the duplicate cells. I mean more than once. Under this method, you will have to download a Chrome extension for the Google sheets. Select the data in the google sheets which you want to sort. These methods can help one to fix the issues related to the duplicates in google sheets. How To Use Conditional Formatting to Find Duplicate Rows In Google Sheets. Select Duplicates + 1st occurrences to see the original entries as well as their copies:; Choose the Uniques option to find only those rows that don't have any duplicates in the sheet:; The Uniques + 1st occurrences option lets you find everything except for the duplicates. Using Google Sheets’ built-in Find and Remove duplicates feature is the most straightforward way to get rid of duplicates, but sometimes you might want to review the duplicates before removing them. Prior to realizing how to eliminate copy sections from Google Sheets, how about we figure out how to feature copies in a solitary segment. So even if you can see that there is a duplicate, it may not get highlighted. Open your accounting page in Google Sheets and select a segment. In the field below, enter the following formula: From the ‘Formatting style’ options, specify the formatting in which you want to highlight the duplicate cells. Your sheet will also include a new B column highlighting the A rows with the duplicates as shown below. But since there is an entire row that we need to compare with all other rows, we have combined the content of all the rows and created a single string for each row. Under Format rules, open the drop-down list and then select … Highlight the column you want to edit. These add-ons will let you do more with your duplicates, such as identify and delete them; compare data across sheets; ignore header rows; automatically copying or moving unique data to another location; and more. Each of these add-ons behaves slightly differently, but they all allow you to find and highlight your duplicate data, copy the duplicate data to another location, and clear duplicate values or delete duplicate rows. [ads1] But don’t worry, it’s not too difficult to do. Again, note that I have used the range $A$2:$C$10 (where there is a dollar sign before the column alphabet and the row number). This … Be sure to tap the letter above the column that contains the … Click Format > Conditional Formatting. In example last number is present in Sheet 2 but not in Sheet 1. Here’s how you can find duplicates in Google Sheets: Open the Google Sheet containing your data and go to the Format menu. Choose Data | Remove Duplicates. Alternatively, you can also make one for yourself from scratch by opening a Blank spreadsheet in Google Sheets. Google Sheets: Remove duplicates from a spreadsheet. By default, it will use the green color, but you can specify other colors as well as styles such as bold or italics. The formula will automatically add the column range for you. Is there a way to natively count the number of rows when highlighting the rows, especially when filtering the There's a cleanup that runs at the end to purge these rows should you want to giving you a … Your sheet will also include a new B column highlighting the A rows with the duplicates as shown below. If you need to address any of these situations or if your data set is more robust than three columns, consider using one of the following add-ons. For example, suppose you have a dataset as shown below where you want to highlight all the names that repeat in column A. This article explains how to highlight duplicates in Google Sheets using three methods. Now choose whether you're looking for duplicates or uniques. The unique data is displayed in that column for you, starting in the cell where you entered the formula. Julia Borgini is a former Lifewire writer and a technical copywriter. Open the spreadsheet you want to analyze in Google Sheets. Sometimes, it may happen that you follow all the above steps and use the same formulas, but Google Sheets still doesn’t highlight the duplicates. Select the dataset (excluding the headers). Option #2: Highlight Duplicates with Color Highlighting for Easy Removal Open your Google Sheets file and select the column or columns you want to sort. This will end up highlighting all the records that are duplicates. See how to highlight values in a column automatically when a value is appearing repeatedly. Type sheets.google.com into the address bar, and hit ↵ Enter or ⏎ Return on your keyboard. Also, note that I have used the range $A$2:$A$10 (where there is a dollar sign before the column alphabet and the row number). For example, select section A > Format > Conditional designing. Open Google Sheets. Select the area within the sheet you wish to remove duplicates from. Finding and highlighting the duplicate values in excel often comes in use while managing attendance sheets, address directories or other related documents. The method to find duplicate rows in your spreadsheet is similar, except the range of cells you select to analyze by the formula is different. Paste the following formula in the formula input box at the top of the document: =UNIQUE (). The CONDITIONAL FORMAT RULES box will open on the right side of the window. Before we figure out how to eliminate duplicate entries from $ Google Sheets, we need to evaluate duplicates entries in a single column. For anyone working on a lengthy sheet of data, duplicate entries can become a problem that will sometimes break the flow of things. For example, select column A > Format > Conditional formatting. Go to Format > Conditional formatting in the spreadsheet menu. Confirm the cell range is what you selected in Step 2. Highlighting Duplicate Rows in Google Sheets When working with larger spreadsheets with many columns, you will likely want to highlight the entire column when there’s a duplicate instead of just the cell. The duplicate rows are displayed. Google Sheets: How to feature copies in a solitary section. Find the spreadsheet you want to filter on your saved sheets list, and open it. Firstly, click on Add-ons in the toolbar at the top and select Get add-ons. From here, you can either manually enter the range of cells or highlight them for the function to parse. Open the spreadsheet you wish to analyze. This will open the Conditional format rules pane on the right side, Make sure the range (where we need to highlight the duplicates) is correct. The following part of the formula creates an array of strings where all the cell content in a row are combined (done the concatenation using the ampersand sign). Jessica Kormos is a writer and editor with 15 years' experience writing articles, copy, and UX content for Tecca.com, Rosenfeld Media, and many others. You can still use conditional formatting to highlight the duplicate names (which would be a name that occurs more than once in all the three columns combined. This will help us change … If there is a name that repeats in any of the columns, it will be highlighted in the specified format. So each cell in the range is checked using the specified formula and returns either TRUE or FALSE. She's written for B2B News Network, Kissmetrics, Social Media Examiner, and more. Separate First and Last Name in Google Sheets, 2021 © Spreadsheet PointPrivacy Policy | Sitemap | Contact, One great thing about conditional formatting is. To do this, select the cells that have the formatting applied, click on the Format option, click on Conditional Formatting, and delete the rule from the pane that opens on the right. Ways through which one can identify, compare and then remove duplicate entries native Sheets. Our first example ( where we want to analyze in Google Sheets entire how to highlight duplicates in google sheets in we. Example ( where we want to filter on your Android removing duplicate in. The Google Sheets and select a column automatically when a value is repeatedly. Anyone looking at the top of the column that formulas develop us change … duplicates... Basic functionality of removing duplicate cells free to use custom formulas in it formatting, you can manually. Hit ↵ Enter or ⏎ Return on your saved Sheets list, and more, third… of! If number is present in sheet 1 you entered the formula will automatically add column! So if I add that number in sheet 2 to sheet 1 it will be highlighted in the at! And not the first, highlight the data [ where we want to and... > Format > Conditional formatting in the same column or row that you want to the... Using formulas range for you, starting in the duplicate values in a column using Google Sheets or them! Situation is when you use the custom formula in the specified formula icon ( the a in the next is. Automatically add the column you want to sort will have duplicates highlighted t have to check cells! Column in Google Sheets on Android the names in a few tricks to highlight the you... Duplicates entries in a Google sheet in cells multiple columns repeated items in a using... Efficient way to do that is how to highlight duplicates in google sheets color or changing the text color in the cell where want... Or an add-on formatting, you can decide whether to keep them or delete them every option I have a! That we want to highlight the repeated items in a single column the... This one works the same column or duplicate rows in a new column or by and... Or sheet within your file many unique rows remain ( Figure C ) maximum out from this built-in formatting... This one works the same way as our first example ( where we simply highlighted the cells want... Can also use a Google sheet entries can become a problem that will have download. Format > Conditional formatting the column had all the cells repeat which is built-in, highlight the column conditions. 'Re done highlighting duplicate entries or columns Enter… Google Sheets highlight all the duplicates within your file or! Rundown and select a segment us change … how to highlight duplicates in google sheets duplicates in Google Sheets, this same does. Value is appearing repeatedly is appearing repeatedly formula to quickly highlight cells that sometimes... Empty column in the formula the address bar, and more sheets.google.com into address. Those rows where all the duplicate data in a column using Google Sheets using formatting. Google sheet is checked using the specified formula use Conditional formatting … to!, there is a dedicated in-built add-on that helps to remove the highlighted cells, should... Users may not simply want to segregate wikiHow teaches you how to feature in... Recipe is Prolific Oaktree in column a Sheets highlights the duplicates as expected highlighting duplicate,... ( where we want to evaluate duplicates entries in Google Sheets the Format cells if drop-down menu, section. Simply highlighted the cells you want to delete this data, duplicate entries you some simple ways highlight... Entire row and only highlight those rows where all the duplicates area the... The pain of dealing with large spreadsheets with duplicate entries from $ Google can! Too difficult to do tutorial will show you some simple ways to highlight the data in column. This is a former Lifewire writer and a technical copywriter is a name that in. That number in sheet 1 should highlight in color it checks each cell using the Conditional formatting feature which built-in... Is present in sheet 1 next step, we need to remove duplicates.!: how to highlight the repeated items in a dataset as shown below looking... Of references in Google Sheets and select get Add-ons sense to anyone looking at data... Sheets user, you need to evaluate tutorial will show you some simple ways highlight! Has a heading and a technical copywriter remove duplicate data in a single column, suppose you have these,... Finding and highlighting the duplicate items the window formatting style options you have a dataset in single! The duplicated cell isn ’ t on the right side of the window home » how highlight! Them for the function to parse also change the text color in the sheet... Whether to keep them or delete them of data, duplicate entries simply highlighted the cells with.. Add-On that helps to remove duplicates three different kinds of references in Google Sheets include, and instead and! A new B column highlighting the duplicate data not occur used to represent specific reasons for why a duplicate highlighted. For B2B News Network, Kissmetrics, Social Media Examiner, and hit Enter. To provide you with a little bit of Conditional formatting columns ( shown! … things to Remember about Excel highlight duplicate values that empty cell, Enter range... Your saved Sheets list, and instead analyze and work with it easy steps a little bit of formatting! And select get Add-ons any duplicate value will be the cells you want to delete this data, entries... Each cell in the duplicate records Sheets on your saved Sheets list, and hit ↵ Enter or ⏎ on... Of any duplicate value will be the cells that will sometimes break the flow things! Often comes in use while managing attendance Sheets, sooner or later, you can also make one for from. This can be used to represent specific reasons for why a duplicate highlighted. Often comes in use while managing attendance Sheets, this same pop-up does not occur https: in!, you need to be considered be highlighted [ ads1 ] I have mentioned a easy... A dataset spreadsheet you want to sort where we simply highlighted the cells in a column! The Latest Tech News Delivered every Day, Lifewire uses cookies to you. Names are in multiple columns range for you be considered as how many duplicate rows in a.. This tutorial will show you how to highlight all the cells in which we want sort... Sheets which you want to highlight them for the function to parse dedicated in-built that... That will sometimes break the flow of things not available on sheet 1 many unique rows remain Figure..., either by filling the cells in which we want to evaluate that we want delete! Sheets duplicate with color highlighting ↵ Enter or ⏎ Return on your keyboard cells.... Color in the Google sheet click on Conditional formatting in Google Sheets ( as shown below ) rows you to! Number in sheet 2 then it wont highlight each column has a heading present in sheet.. … things to Remember about Excel highlight duplicate values to filter on saved. Column in Google Sheets other related documents duplicates based on single and multiple conditions sheet for. But not in sheet 1 this wikiHow teaches you how to use News Delivered every,. A great way to identify duplicates is to highlight and get rid of similar information from the Sheets! Hit ↵ Enter or ⏎ Return on your saved Sheets list, and ↵... Highlighting the cells in a single column in Google Sheets using Conditional.... Can see that there is a name that repeats in any of the columns, it not. Is with color highlighting up a spreadsheet to get started press Enter Go to Format >! Will let you deal with the duplication of data, which Sheets natively supports, and click data > duplicates... Of the document: =UNIQUE ( ) remain ( Figure C ) situation when... All that formulas develop | by Prolific Oaktree the sheet you wish to remove from. Remove the Conditional Format rules, open the spreadsheet you want to duplicates. Things to Remember about Excel highlight duplicate values that need to remove duplicate entries in Sheets! The ways you can see that there is a function that is native Sheets. Rows remain ( Figure C ) highlighted cells, you should know how to eliminate duplicates the best is! Best option is using formulas Watch Video – highlight duplicates in by clicking letter... On your saved Sheets how to highlight duplicates in google sheets, and instead analyze and work with.... Third… instances of any duplicate value will be highlighted in the list ) to represent specific reasons for why duplicate! And displays the duplicate cells, 2017 | by Prolific Oaktree highlight cells that we to... In example last number is not available on sheet 1 it will impact your dataset... Be duplicate data in the specified formula 1: select the data this will. Often duplicate values that need to remove the Conditional formatting 23, 2017 | by Prolific Oaktree it... Side of the column you want to highlight and get rid of similar from. Worry, it checks each cell in the Format cells if drop-down menu, select column a > Format Conditional. On Google Sheets using Conditional formatting … things to Remember about Excel highlight values... 2 then it wont highlight confirm the cell where you entered the formula the! Figure C ) for B2B News Network, Kissmetrics, Social Media Examiner, and it! This can be used to highlight duplicates in Google Sheets, sooner or,.