Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.
SOLVED

Highlighting Duplicate Values in a Report Column

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 4

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. 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

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. 

Avatar

Level 2

Thank you!