DanielAtGSU

Apr 15, 2022Copper Contributor

# Help: Highlighting Only the First Duplicate

I have two columns of data. I'm comfortable with conditional logic and I've made the data consistent between the two columns so that highlighting duplicates is error-proof. Here's where it gets b...

- Apr 15, 2022
Select B1:B9 (or to the end of the data). B1 should be the active cell in the selection.

Create a rule of type 'Use a formula to determine which cells to format' with formula

=AND(ISNUMBER(MATCH(B1,A:A,0)),COUNTIF(B$1:B1,B1)=1)