How to apply shading to alternate rows and columns in Excel? In order to apply shading to alternative rows and columns in Excel, you need to use Conditional Formatting.

If you're using Excel 2007, you have a whole range of new formatting tools at your disposal, including the alternate row shading offered through the Format As Table options.