How to Highlight Duplicates on Google Sheets (in 5 simple steps)Use conditional formatting, highlight a column, use a custom formula: =countifs([range],[first cell in range])1#spreadsheet#googlesheets#formula·lido.app·Jan 7, 2022How to Highlight Duplicates on Google Sheets (in 5 simple steps)