Formaing cells

[shaiyac]

Hello

I have a data sheet with hundereds of rows sortes by Column Cat.No.
some rows have the same cat.No.(Cat.No. 0566A55 appears in 3 rows for example )
i want to have all rows with the same Cat.No. with same color but when the Cat.No. changes. i want that the color overturned to a different(a random color red,green,etc...)

Thanks

 

[shaiyac]

Thank You VM .
It solved my Prob.
Shai

 

[T. Valko]

Thank You VM .
It solved my Prob.
Shai

You're welcome. Thanks for the feedback!