how to shade every other 5 rows

[chiechka]

how to shade every other 5 rows

 

[JMay]

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

Ok, out

Again Click on Row-Header (only on 1st row) - Select Format-Painter
and click on row-header 2 and drag down the row-header column to say 100
That should get you rows 1 - 100.

 

[gls858]

how to shade every other 5 rows

Here's a link to a handy little free tool called ASAP Utilities

http://www.asap-utilities.com/

It has MANY useful tools. One of them being highlight every nth row.

gls858

 

[chiechka]

now is there a formuala for it to shade 5 rows and then skip 5 rows and so
on....

 

[Ron Coderre]

Try something like this:

Select the rows to be impacted, with A1 as the active cell

From the Excel main menu:
<format><conditional formatting>
Formula is: =MOD(CEILING(ROW()/5,1),2)=1
Click the [format] button and set the shading pattern
Click [OK]
Click [OK] (again)

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Stan Brown]

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.

 

[chiechka]

Thanks the formula works great !

Try something like this:

Select the rows to be impacted, with A1 as the active cell

From the Excel main menu:
<format><conditional formatting>
Formula is: =MOD(CEILING(ROW()/5,1),2)=1
Click the [format] button and set the shading pattern
Click [OK]
Click [OK] (again)

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP

now is there a formuala for it to shade 5 rows and then skip 5 rows and so
on....

 

[chiechka]

The formula it works great and thanks for the explaination.