I have a spreadsheet of patient data (several thousand records) where I need a way to indicate whether there's a duplicate patient. We know there's a duplicate if the last name and the date of birth are the same, which are in two separate columns. Does anyone know how to use conditional formatting to highlight either the row or those cells when there's a duplicate in two columns? This is a sample of what the data look like (fake data):
Google-sheets – Highlight duplicate based on two columns
conditional formattinggoogle sheets
Related Topic
- Google Sheets – How to Lock or Protect Conditional Formatting
- Google-sheets – Conditional Formatting based on other column
- Google-sheets – Google Sheets conditional formatting for multiple columns
- Google-sheets – Conditional Formatting IF/AND Google Sheets
- Google Sheets – Highlight Row if Partial Text Matches in Two Columns
- Google Sheets – Conditional Formatting on Merged Cells
- Google Sheets – Conditional Formatting Based on Data in Two Columns
- Google-sheets – Google Sheets: How to compare multiple rows/data ranges AND display the MATCHING/duplicate values
Best Answer
I believe the following forula will work for you: