Google Sheets – Highlight Duplicate Data in a Column or Row

Learn how to use conditional formatting in Google Sheets to highlight cells with duplicate data.

To do a row instead of a column, use 1:1 to reference all of row 1, just like you use A:A to reference all of column A.

If you live in a country that uses a comma as a decimal separator, use semi-colons instead of commas.

Use an add-on to manage duplicate:

Learn more from Prolific Oaktree:
🌳 Next VideoGoogle Sheets | Sort and Filter by Color
🌳 Related Playlist – Google Apps | Full Tutorials –

#googlesheets #spreadsheets #duplicates

Language »
Thanks !

Thanks for sharing this, you are awesome !