how to shade every other 5 rows
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
"chiechka" wrote:
now is there a formuala for it to shade 5 rows and then skip 5 rows and so
on....
"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
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.
"chiechka" wrote:
how to shade every other 5 rows
|