Alternating colors to differentiate rows

Hi Guys!

I hope someone can guide me how to achieve what I need. I am looking for a way to differentiate rows by colors based on the data from specific column. This is how raw table looks like and what I would like to get:

Is it possible to set this up for semi-automatic use (macro / script)?

Thanks in advance for ideas!

Hello,
search the forum for conditional formatting, find an example attached.
CF.ods (11.2 KB)

1 Like

AND($A2<>"";MOD(SUMPRODUCT($A$1:$A1<>$A$2:$A2);2))

CF_2.ods (13,3 KB)

1 Like

LibreOffice Help about Applying Conditional Formatting.