How to highlight duplicates in Google Sheets
The COUNTIF custom-formula approach, when it breaks, and how to handle case, whitespace, whole-row matching, and later-occurrence-only highlighting.
Guides
Google Sheets duplicate guides.
Straightforward explanations of how duplicate detection actually behaves in Google Sheets—formulas, matching rules, and the edge cases that make identical-looking values fail to match.