Format Rule: Duplicate Data

I would like to create a format rule that would highlight duplicate data in a column. Example, Column A has the data set:

Red
Blue
Green
Blue
Black
Orange

Then the format rule (underline, bold, whatever) would only apply to “Blue” because it is a duplicate.

Any thoughts? I’m sure there is a simple answer.

Thanks!
Nick

Same pattern I use for Valid If to prevent duplicates:

ISNOTBLANK(
  FILTER(
    "table-name",
    ([_THISROW].[column-name] = [column-name])
  )
  - LIST([_THISROW])
)

Thanks. I have at least one place I need to apply this.

1 Like