I have ROWS of names rather than columns. I simply want to highlight any time a name is duplicated in further rows.
Currently working with the names from B2:K2, which test duplicates in various cells beneath - C5, D8, E12, etc etc. I just can't figure it out, although I swear it's so simple.
SAMPLE SHEET = https://docs.google.com/spreadsheets/d/1nTQ4LNInbFyoo0mJIWOnT1aPYB4ZzQon0L37YiAWI3w/edit?gid=0#gid=0
You can apply the following conditional formatting custom formula to the range B2:K
:
=COUNTIF($B3:$K,B2)
This formula highlights the value in the current row if it's present in any row below.