Shading Alternate Rows in Excel
Finding it hard to follow a row across the page in your Excel
spreadsheet? Thinking what happened to that striped computer paper we used
to run reports on? Well now you can have those stripes in your spreadsheet
thanks to Excel's conditional formatting feature. This will make thing
easier to find on screen or on paper.
- Highlight the range of cells that you want
- From the drop down menu select
Format -> Conditional Formatting this
will bring up the the Conditional Formatting dialog box.
- From the first drop down option in the
Conditional Formatting dialog box select Formula
is, then in the second box type in the formula =MOD(ROW(),2)=0 in the
- From the Conditional Formatting dialog box
click on the Format button to bring up the Format Cells dialog box.
- By clicking on the patterns tab you can now
select a color for the background of the alternate rows. Make sure you
choose a light color which will allow you to see the content of the
cells. You can do any other formatting you would like which is available
here such as font, font type, color etc.
As you can see we get a preview of what the shaded row will look like and
can adjust the formatting until we like the results.
- Now that we are happy with our selections we
simply click OK to accept the formatting options your spreadsheet now has
every other row highlited.
The great part about this is that the formatting
stays in every other row wether you delete a row, insert a row etc.