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
  • 2 replies
  • 500 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. 

2 replies

RowvillBh1
User Group Leader
RowvillBh1User Group LeaderAccepted solution
User Group Leader
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!