How to Highlight Duplicates in Google Sheets | Scribe
This guide was created with Scribe in 21 seconds. Sign in and create your own!
How to Highlight Duplicates in Google Sheets
Alejandra Arciniegas |
0 step |
21 seconds
Google Sheets
In order to highlight duplicates in Google Sheets, you should first navigate to Google Sheets.
Once you open your spreadsheet, highlight the column or row you want to highlight.
Then, go to "Format".
And then, you should click on "Conditional formatting".
Then, you should click on the dropdown below "Format rules".
Now, you need to scroll all the way to the bottom of the dropdown. Then, you should click on "Custom formula is".
Now, you need to click on the field of "Value on formula"
And then, type the COUNTIF formula, which is "=COUNTIF (ROW:ROW, ROW2)>1". So, in this case, since I'm working with the column B, the formula looks like **=COUNTIF (B:B, B2)>1.** And that's all!
Documents you might like
0 Selected
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key