Forum Discussion
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...
You may apply such rule
with formula
=(COUNTIFS($A$1:$A1,$A1,$C$1:$C1,$C1)=2)*($C1<>"")
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
SergeiBaklan Thanks so much! I really appreciate it!
You are welcome