Coloring Duplicate records in reports
Hi All
We have field called "ISC ID" in account object and the requirement was to list down all records which have the ISC ID more than once. I managed to get the report using the function COUNT( ISC ID by ISC ID) and filter > 1. I got the correct results as well.
Now the requirement is to color these duplicate records as below
ISC ID
123
123
123
456
456
89
89
All 123 should have the same color and then 456 records should have the same color and then 89 records another color. Is this possible ? I should be able to highlight that cell or highlight that row itself. In case you have a solution, please let me know.