How to apply conditional formatting on a column where two duplicate vales are noted

[nevilledhamsiri]

As per attached qvd under MY column there are two duplicates (818308@2) ,need to highlight them

Thanks

Neville

[Frank_Hartmann · Accepted solution]

Backgroundexpression for NET CLAIMS:

Aggr(NODISTINCT If(Count({<DESCRIPTION={'NET CLAIM'}>}MONTH_ACT) > 1, LightGray()), MONTH_ACT)

hope this helps

[nevilledhamsiri]

Thanks a lot

Neville