Application Tips

Alternation Row Colors in Excel

Follow the steps below to set up alternating row colors in Excel:

  • Highlight the rows that you wish to apply the formatting to. You can also select the entire sheet.
  • Under the Format menu, select Conditional Formatting.
  • When the Conditional Formatting window appears, select “Formula Is” in the drop down list.
  • Enter the following formula: =mod(row(),2)=1
  • To select the color you want to see in the alternating rows, click on the Format button.
  • In the Format Cells window, select the Patterns tab. Then select the color you want to use and click OK.
  • Click OK again to close the Conditional Formatting window.

Leave a Reply