Automatic Row Formatting

C

Chris Hughes

I have spreadsheet with a lot of rows of data. When I print it out it is
very hard to read without laying a straight edge across the page to guide the
eye along the row. We used to use multisheet feeder paper with alterante
colour rows on when we used our old dort matrix printer.

My question is whether it is possible to make Excel format alternate rows
with a different colour to help guide the eye across the row?
 
M

Max

Chris Hughes said:
.. My question is whether it is possible to
make Excel format alternate rows
with a different colour to help guide the eye across the row?
Click to expand...

One quick way to get alternating rows coloured nicely ..

Press CTRL+A
to select the entire sheet

Click Format > Conditional Formatting

Make the settings
Under Condition1
Formula Is| =MOD(ROW(),2)
Click Format button > Patterns tab > Light green? > OK

Click OK at the main dialog
 
Top