Highlighting Duplicate Values in a Report Column | Community
Skip to main content
New Participant
April 8, 2025
Solved

Highlighting Duplicate Values in a Report Column

  • April 8, 2025
  • 1 reply
  • 465 views

Is there a method to highlight duplicate values in a column in a report, similar to how Excel's conditional formatting works for highlighting duplicates?

For example, if a column contains the value "123" twice, it should be flagged as a duplicate.

Best answer by RowvillBh1

Hi Talia,

Worfront's conditional formatting only looks at the corresponding row and does not look at the full set. As a workaround, you could probably group your report based on the field where you want to find duplicates and then look for any grouping that has a count of more than 1. 

1 reply

RowvillBh1
RowvillBh1Accepted solution
New Participant
April 8, 2025

Hi Talia,

Worfront's conditional formatting only looks at the corresponding row and does not look at the full set. As a workaround, you could probably group your report based on the field where you want to find duplicates and then look for any grouping that has a count of more than 1. 

TaliaFiAuthor
New Participant
April 8, 2025

Thank you!