In Google Sheets, it seems that masking an odd number of rows in a range somehow defeats the alternate color formatting (adjacent rows will occur with identical colors). Is there a workaround using, e.g. conditional formatting instead?
I guess that you could make a conditional formatting with the personalized formula option and put something like:
You should replace A1 with the first cell of the range you're working with. Then every odd row will be applied the formatting you choose If this doesn't help, share a sample spreadsheet ;)
Edit: just corrected the formula.i forgot the row part
That can be done by using a helper column. Put this formula in cell
H1 (in row 1):
You can then format a range with zebra stripes with this conditional formatting custom formula rule:
$H$1:$H1, you should replace the two instances of
1 with the row number of the first row in the range you are formatting.
Note that the helper column should not be be hidden, although rows within that column may get hidden per your preference. You can resize the helper column to a minimal width of
2 if it gets in the way.