How to conditional formatting duplicate cells in a column in Google sheet?
In Excel, the Conditional Formatting feature can help you to highlight duplicate values quickly and easily. But, how could you highlight the duplicate cells in a column in Google sheet?
Conditional formatting duplicate cells in a column in Google sheet
Highlight duplicate cells in a column in Excel worksheet with Kutools for Excel
Extract decimal numbers from text string with formulas
There is also a Conditional formatting feature in Google sheet, with it, you can highlight the duplicate cells at once, please do as follows:
1. Click Format > Conditional formatting, see screenshot:
2. In the Conditional format rules pane, please do the following operations:
(1.) Select the column data that you want to highlight the duplicate values in the Apply to range text box;
(2.) In the Format cells if section, choose Custom formula is from the drop down list, and enter this formula: =countif(A:A,A1)>1 into the text box;
(3.) At last, select a formatting from the Formatting style section.
(4.) Then, you can see all the duplicate cells have been highlighted at once.
Highlight duplicate cells in a column in Excel worksheet with Kutools for Excel
To highlight duplicate cells in Excel workbook, the Kutools for Excel’s Select Duplictae & Unique Cells utility can help you to solve this job.
| Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. |
After installing Kutools for Excel, please do as follows:
1. Select the column data that you want to highlight duplicates, and then click Kutools > Select > Select Duplictae & Unique Cells, see screenshot:
2. In the Select Duplicate & Unique Cells dialog box, select Duplicate (Except 1st one) or All duplicates (Including 1st one) as you need in the Rule section, then choose one background color under the Processing of results section to shade the duplicate cells, and then, click Ok button, and all duplicate cells have been highlighted as following screenshot shown:
Click to Download Kutools for Excel and free trial Now!
Best Office Productivity Tools
Easy to Uninstall Completely | Supports Office/Excel 2007-2021 and 365 | Full-Featured 30-Day Free Trial | Available in 44 Languages
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
