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