Excel: Automatically Color Every Other Row

July 4, 2013 / Updated: March 22, 2014 / Lena Shore

ExcelWish you could make your Excel spreadsheet a bit easier to read by coloring every other row? What if your spread sheet is huge and you don’t want to do it by hand? Fear not! There are a couple ways to do this.

The Quick Way

I feel that this way works best if you are starting from scratch, but you could apply it to an existing spreadsheet.

  • Look at the tabs under the top toolbar. Click on Tables
  • Highlight the area you want to to apply the style to
  • Click on one of the Tab Styles

excel-alternate-row-colors

The Custom Way

  • Highlight the area you want to to apply the style to
  • Go to the main menu and go to–> Format –>Conditional Formatting. Click the “plus” to create a new rule.
    • PC: Select “Use a formula to determine which cells to format”
    • Mac: Select “Classic” in the drop-down box and choose “Use a formula to determine which cells to format”
  • Put =MOD(ROW(),2)=1 in the formula box
  • From here you can click the dropdown and adjust your styles in more detail.
  • When you are done select OK.

excel-custom-formating

Posted in

Lena Shore

Lena is a full-time freelancer and nerd that specializes in web development, graphic design, and illustration. She enjoys building things, learning new things, pursuing creative endeavors, and giving free advice.

Leave a Comment

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Archives