Zebra pattern in libreoffice

Question

In Libreoffice Calc, I want to separate in a list of artists and titles, the artists by means of a different color.

That’s the result I wish:

As you can see, I wish in column C a formula to indicate whether the artist of the line has in the surroundings different artists. A sequence of artists would have the same color, while three alternating artists would have alternating colors. Lastly I would make a conditional formatting based on the results of column C.

Answer 1

Answer:

=SE(A2=A1;D1;MOD(D1+1;2))

https://stackoverflow.com/questions/27020/alternating-coloring-groups-of-rows-in-excel