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     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