MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need to shade/color every other row in a worksheet


Posted by Jennifer on December 26, 2001 9:51 AM

And I've never used VB before - if this is how it has to be done, please give it to me in babyspeak!

Thanks!


Posted by Jacob on December 26, 2001 10:04 AM

Hi

This should help it is on Mrexcel quick tips section.

How can I format a worksheet to have alternating green and white rows like a "greenbar" report?Select the range you want to format. Format > Conditional Formatting. In the left dropdown, change "Cell Value is" to "Formula Is". In the formula box type =MOD(ROW(),2)=0. Click the "Format..." button. Click the Patterns tab and pick a color.


Jacob

Posted by jennfurr on December 26, 2001 10:06 AM

thanks, i just found it - and it works! glory be!

: And I've never used VB before - if this is how it has to be done, please give it to me in babyspeak! : Thanks!