Alternating colors for duplicate cells

[schweizer]

Hi I would like to be able to set a conditional format to color matching (duplicate) cells. Please see attached for an example of what I have and what I would like.
Thank you very much!
Alternating Color Formating_Duplicates.xlsx

[duffry]

Not sure about having a different colour for each set but alternating colours can be achieved with:

Please Login or Register  to view this content.