Hide Row/s (single/grouped) based on cell value of column in the r
 

Any ideas how we could;

Starting from a row (say 10) and for each subsequent row, to last row of
used range;

If cell value in column C of the row = 0, then hide the row (if not already
hidden).

If cell value in column C of the row 0, then unhide the row (if hidden).

To make it more interesting;

Only read the first row of any row grouping and hide/unhide all the rows in
that group, based on the condition of the first row.