Shading every 2 rows

[shaftdx]

ok I know how to shade every other row

=MOD(ROW(),2)=0

that I want to do is shade 2 rows on 2 rows off I tried manipulating this formula but could not get anything to work.

 

[Rick Rothstein]

Give this formula a try...

=MOD(INT((ROW()-1)/2),2)>0

Note: This formula, as written, requires you to start on an odd row number.

 

[shaftdx]

Give this formula a try...

=MOD(INT((ROW()-1)/2),2)>0

Note: This formula, as written, requires you to start on an odd row number.

That worked exactly how I wanted thank you!!