Highlight duplicate values in a report column

[AbhipsitaBo]

Hi,

Is there a way to highlight the duplicate values in a column. Similar to excel conditional formatting > Highlight duplicate values

In simple words, if a column has the value “231” twice then it will be considered as duplicate.

[Doug_Den_Hoed__AtAppStore]

Hi Abhipsita,

Not that I'm aware of -- conditional formatting is restricted to "that row" independent of any others and does not account for aggregates -- but instead, you could group by the column in question, return all rows, and search the page for (2), (3), (4) etc to "find" any with more than (1) in the group.

Regards,

Doug

[AbhipsitaBo]

Thanks Doug Thats a great workaround.