Excel Spreadsheet Alternate Row Shading

By Ed Vignone

Did you ever try to read across a row in a spreadsheet and inadvertently skip to the next line? I f each alternate row was shaded it would look better and would be easier to read. This can be easily accomplished by using Excel’s “Conditioning formatting” feature.

 

• Select the range for Formatting by highligting.
• From the Tool Bar select “Format”, then “Conditional Formatting”
• A conditional format dialog box will appear.

 

 

• Select “Formula Is”, then enter the formula “=MOD(ROW(), 2)=0 “.
• Click the “Format” button then select the “Patterns” tab and click on a color for shading the alternate rows. (Note! text is easier to view through lighter colors).

 

 

• Return to your spreadsheet by clicking “OK” twice.

SPREADSHEET WITHOUT ROW SHADING

 

 

SPREADSHEET WITH ROW SHADING