Find Duplicates in Other Column

Google Sheets: Highlight Duplicate Names Between Two Columns with Conditional Formatting (MATCH) This video shows how to find and highlight duplicate names between two Google Sheets columns using Conditional formatting instead of searching one-by-one. Using an example of event registrants in column B and attendees in column D, it demonstrates selecting the B column range, opening Format → Conditional formatting, choosing “Custom formula is,” and applying an exact-match MATCH formula starting at B1 (e.g., MATCH(B1, D:D, 0)) to highlight names in column B that also appear in column D. It also shows adjusting the applied range (e.g., B1:B9995 or B:B), choosing a highlight color for visibility, and confirms the formatting updates automatically when new names are added. 00:00 Find Duplicate Names 00:38 Open Conditional Formatting 01:01 Write MATCH Formula 01:41 Highlight Matches Fast 02:11 Auto Updates New Entries 02:22 Subscribe And Next Videos