Ask Your Question
0

Calc group or select rows and color alternating groups [closed]

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

novelluser2002 gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-11 08:14:29.259122

1 Answer

Sort by » oldest newest most voted
0

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

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

Question Tools

1 follower

Stats

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

Seen: 594 times

Last updated: Aug 27 '16