google-sheetsduplicatesconditional-formatting

Highlighting duplicates in Google Sheets (from a source of 1 row, not a column)

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

Solution

  • 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.