Highlighting Duplicate Values in a Report Column | Community
Skip to main content
Level 2
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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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
Level 5
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
Level 2
April 8, 2025

Thank you!