MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Statement Style formating (every other row)

Posted by Joe Goodman on October 10, 2001 9:22 AM

I have a worksheet with many rows of values. I want to make it easier to follow accross. I think it would be helpful if every other row was shaded or formated different than the one above. Is there a easy way to do this? I have like 1200 rows by 22 columns and it would not be feasable to format them one by one.

Thanks in advance

Posted by IML on October 10, 2001 9:47 AM

You could use conditional formatting for this. Select a cell with the range and goto format - conditional formatting. change the "cell value is" box to formula is. type the formula =MOD(ROW(),2)=0 and select the shading you would like for every other row.

Now highlight this cell and hit the format painter (paint brush) and extend it over your entire range. If you want to reverse the line, either add a line or change formula to =MOD(ROW(),2)<>0<p>good luck

Posted by Aladin Akyurek on October 10, 2001 9:49 AM


Select the range of interest.
Activate Format|Conditional Formatting.
Select "Formula Is" for Condition 1 and enter the following:


Activate Format, select a color on the Patterns tab.

Click OK.



Posted by Don C on October 11, 2001 6:03 AM

Highlight the rows, go to Format/Autoformat and choose something like List 2 or List 3. No formulas needed.