Forum Discussion
patharvey-001
May 04, 2020Copper Contributor
Trying to highlight duplicates
Hi there. I am trying to come up with a formula that will allow me to highlight duplicate cells but only if it is a duplicate for a value in another column as well. What I mean is: I wa...
SergeiBaklan
May 04, 2020Diamond Contributor
You may apply such rule
with formula
=(COUNTIFS($A$1:$A1,$A1,$C$1:$C1,$C1)=2)*($C1<>"")patharvey-001
May 04, 2020Copper Contributor
SergeiBaklan Thanks a lot for your response!
What would the formula be to make it highlight every duplication after the first? It looks like right now it only highlights the second instance but not the third, fourth, fifth etc
- SergeiBaklanMay 04, 2020Diamond Contributor
- patharvey-001May 04, 2020Copper Contributor
SergeiBaklan Thanks so much! I really appreciate it!
- SergeiBaklanMay 04, 2020Diamond Contributor
You are welcome