You can shade alternate rows to make the data in your worksheet easier to scan and soothing to the eyes. This is also known as color banding. In this article, we will learn how to shade every other row in Excel.
Also read: Select non-adjacent cells in Excel
Here’s the step to step guide to shade alternate rows in Excel
- Select the range of cells that you want to format.
![How to shade alternate rows in Excel? 3 shade alternate rows](https://quickexcel.com/wp-content/uploads/2021/06/range-selection.jpg)
- Click on Home > Conditional Formatting present in the Styles tab.
![How to shade alternate rows in Excel? 4 conditional formatting in styles tab](https://quickexcel.com/wp-content/uploads/2021/06/conditional-formatting-in-styles-tab.jpg)
- Select New Rule from the drop-down list.
![How to shade alternate rows in Excel? 5 shade alternate rows](https://quickexcel.com/wp-content/uploads/2021/06/conditional-formatting-drop-down.jpg)
- In the Conditional Formatting dialog box, click on Use a formula to determine which cells to format option present in the Select a Rule Type section.
![How to shade alternate rows in Excel? 6 shade alternate rows](https://quickexcel.com/wp-content/uploads/2021/06/conditional-formatting-dialog-box.jpg)
In the Format values where this formula is true box, type the formula:
- =MOD(ROW(),2)=0 for shading even numbered rows or
- =MOD(ROW(),2)=1 for shading odd-numbered rows.
![How to shade alternate rows in Excel? 7 format rule](https://quickexcel.com/wp-content/uploads/2021/06/format-rule.jpg)
- Then click on the Format button to open the Format Cells dialog box.
![How to shade alternate rows in Excel? 8 format cells dialog](https://quickexcel.com/wp-content/uploads/2021/06/format-cells-dialog-box.jpg)
- Click on the Fill tab to select a color for shading. After selecting the color click on OK.
![How to shade alternate rows in Excel? 9 fill dialog box 3](https://quickexcel.com/wp-content/uploads/2021/06/fill-dialog-box-3.jpg)
- After seeing the preview in the Conditional Formatting dialog box, click on OK, to apply the shading.
![How to shade alternate rows in Excel? 10 formatting preview 2](https://quickexcel.com/wp-content/uploads/2021/06/formatting-preview-2.jpg)
The final result looks like this:
![How to shade alternate rows in Excel? 11 shaded alternate rows](https://quickexcel.com/wp-content/uploads/2021/06/shaded-alternate-rows.jpg)
Conclusion
In this tutorial, we learned how to shade every other row in Excel using Conditional Formatting.