When it comes to shading every other row in Excel, most gurus will immediately point you to conditional formatting, where you will have to invest some time in figuring out an ingenious mix of MOD and ROW functions.
A better way is to have row or column colors alternated automatically and this article is going to show you how you can quickly do this. While it is a relatively easy job to highlight rows of data manually in a small table, it could be an arduous task in larger ones. It is a common practice to add shading to alternate rows in an Excel worksheet to make it easier to read. You will also learn how to apply Excel banded rows and columns and find a few smart formulas to alternate row shading based on a value change.
This tutorial explains how you can alternate row colors in Excel to automatically highlight every other row or column in your worksheets.
