Friday, November 21, 2014

yogi_Conditionally Format Rows With Alternate Set Of Specified Number Of Rows (also whether pattern should start with row 1)

               Google Spreadsheet   Post  #1843
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov-21-2014
post by Sebatian Capatina:!category-topic/docs/spreadsheets/0jJdEt-y8kk
How to change the colour of four rows, every four rows?

I would like to have four rows with a different background colour, every four rows.

4 rows white background,
4 rows grey background.

Is someone able help with the custom formula in the conditional formatting field?

following is a solution to a bit more generalized problem