Alternate row colors except repeating values

[neha_sharma1275]

Hi Experts,

I have a requirement where the rows should be alternate colors but for repeating values the color shouldn't change. I have achieved the alternate row colors(below is the screenshot) using this formula in the Background color of dimension [Part ID]

=if(Even(RowNO(total))=0,LightBlue(),Green())

    BUT  I am not able to make the same row color if the values repeat. for example, in the below screenshot it should be - 1st Part ID - Blue, 2nd Part ID - Blue again , 3rd Part ID - Green and rest of the rows having alternate row colors.

Help is highly appreciated !

Thanks,

Neha

[Ben_at_Kohls]

I have the same issue if anyone has any ideas.