I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL
function.
How would I be able to give just the subtotals their own set of alternating colors?
Example (cell content / color):
row1 / white
row2 / gray
=subtotal() / dark gray
row4 / white
row5 / gray
=subtotal() / very dark gray
row7 / white
row8 / gray
=subtotal() / dark gray
I know from other source how to format just the visible rows, but this still leaves out Subtotals.
How can Subtotals have their own alternating colors?