"chiechka" wrote:
how to shade every other 5 rows
"JMay" wrote:
Click on the Row-Header (the actual 1 in the left margin) - then Format,
Conditional Formatting, Select Formula Is drop-down in box enter:
=MOD(ROW(),5)=0
Click Format button, select Gray Pattern
Fri, 27 Apr 2007 11:02:06 -0700 from chiechka
:
now is there a formuala for it to shade 5 rows and then skip 5 rows and so
on....
Sure. =MOD(ROW()-1,10)<5
"Mod" is the modulus function, the remainder after division. If you
divide by 10, you're taking the last digit. So if ROW() begins at 1,
then ROW()-1 begins at 0. The result of MOD is 0, 1, 2, 3, 4, 5, 6,
7, 8, 9, 0, 1, 2, 3, etc.
Testing for <5 gives you the first 5 rows, skips the next 5, hits the
next 5, and so on.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/