Ask Your Question
0

Calc group or select rows and color alternating groups

asked 2016-08-27 15:51:49 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-27 16:25:15 +0100

mark_t gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-27 15:51:49 +0100

Seen: 339 times

Last updated: Aug 27 '16