I have some data which is in groups of irregular numbers of rows, e.g.
1 Dragon 2 Dragon 3 Dragon 4 Dog 5 Dog 6 Cat
(edited to avoid confusion)
I want to colour each group in alternate colours so it is easy to see the groups. So in the exmple above rows 1 -3 would be pale yellow, rows 4-5 would be pale blue, row 6 would be pale yellow and so on.
I think there must be a way using styles and conditional formatting but I just can’t do it. (or must I resort to macros?) Currently the dataset is small so I can do it by hand, but it will grow soon and I’d like to find a way of doing this.
Any ideas? Thank you