How to Highlight Duplicates in Google Sheets | Scribe

How to Highlight Duplicates in Google Sheets

  • Alejandra Arciniegas |
  • 0 step |
  • 21 seconds
  • Google SheetsGoogle 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