Hi all
Have searched multiple places, and tried a few different options - but I'm still stuck!
I have a sheet that includes a macro assigned to a button, when pressed it hides any rows of data that are shaded in dark grey.
I want to shade groups of rows, depending on the number in column A. For example when the number changes then alternate between light grey and white, like banding rows in a table.
I want it to shade only visable rows, not the ones hidden.
Believe it may be the aggregate formula, or subtotal one - and I'm happy to add a helper column to get this working.
Thanks!!
What I have: