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     www.energyefficientbuild.com.   Nov-21-2014

post by Sebatian Capatina:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/0jJdEt-y8kk
How to change the colour of four rows, every four rows?

Hi, 

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

4 rows white background,

then

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