The ROW function returns the row number of the current cell and then the MOD function is used to obtain the remainder after dividing this number by 2. This ...
I'm doing a simple conditional formatting. Formula format applies to =MOD(ROW(),2)=0. Fill colour =$A$2:$F$1048576 And it works! But it colours everything down ...
To apply color to alternate rows, in the Format values where this formula is true box, type the formula =MOD(ROW(),2)=0. To apply color to alternate columns, ...
I'm building an Excel sheet that Adds 2 onto the previous cell every nth row as specified in cell $C$1. (It's for working out where to place increase stitches ...