Calc group or select rows and color alternating groups

[novelluser2002]

I have a spreadsheet with rows that need to be grouped (selected), the number of rows vary based on the data collected.
Rows need to be grouped (selected) based on the content in a Column, and then color the row groups.

In this example I made the font italic the group of rows is based on the “Animal” column.


For example Unformated:

Animal Part Qty

Man Leg 2

Man Arm 2

Man Hand 2

Cat Leg 4

Cat Tail 1

Dog Leg 4

Rat Eye 2


Formated:

Animal Part Qty

Man Leg 2

Man Arm 2

Man Hand 2

Cat Leg 4

Cat Tail 1

Dog Leg 4

Rat Eye 2

Now I want to color every other group of rows, but not all groups have the same number of rows.

How do I automate this for thousands of rows with hundreds of groups?



Thank you for your time, David.

[mark_t]

Add a helper column to calculate the grouping and then use this in conditional formatting to select the format of the data. Attached example Untitled 14.ods