Skip to main content
Level 2
Apr 8, 2025 4:18 PM UTC
Solved

Highlighting Duplicate Values in a Report Column

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.
RowvillBh1
RowvillBh1Accepted solution
User Group Leader
Apr 8, 2025 4:48 PM UTC

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
Apr 8, 2025 4:48 PM UTC

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. 

Translate
TaliaFiAuthor
Level 2
Apr 8, 2025 6:14 PM UTC

Thank you!

Translate