Forum Discussion
Conditional Formatting Duplicates in Two Columns
Hello, I have a spreadsheet where I track calls my office receives. I have a table that includes the date and name for each call. Sometimes calls are entered in the spreadsheet multiple times. I wou...
Hello nprager1450,
Select the Name column, go to Conditional Formatting, choose New Rule, Use a formula to determine which cells to format, and enter the formula =COUNTIFS($A$2:$A2, $A2, $B$2:$B2, $B2) > 1 assuming dates are in column A and names in column B starting at row 2. This will highlight only the second and later duplicates for the same day.
