In LibreOffice Calc, I want to separate in a list of artists and titles, artists by means of a different color.
This is the result I want:
As you can see, I wish in column C a formula to indicate if the line artist has different artists in the vicinity. A sequence of artists would have the same color, while three alternating artists would alternate color. Finally I would do a conditional formatting based on the results of column C.