Automatic Row Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: Can I have a moving colored band for active row ? 1
Conditional Formatting of a row 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional formatting in Excel 2010 2
Row Format by Group 5
Formula Help 9
Conditional Formating based on Data Validation 3
Conditional Formatting of a Row 2

Back
Top