Forum Discussion
Conditional formatting to highlight duplicates across two columns
Hi, I'm looking for some help to highlight duplicate data across multiple columns. For example I wish to use conditional formatting or similar to show me at a glance if I have multiples of John Smith...
=IF(COUNTIFS($A$1:$A$6,A1,$B$1:$B$6,B1)>1,"Duplicate","")
A similar result can be returned with this formula.