'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, 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. Try something like this: Select the rows to be impacted, with A1 as the active cell From the Excel main menu. '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 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. ![]() ![]() Now is there a formuala for it to shade 5 rows and then skip 5 rows and so on.
0 Comments
Leave a Reply. |