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.

How do you set up a worksheet with alternating colored rows like the traditional columnar pad design? There are many ways, but the easiest, for both Excel 2003 and 2007 is with a Conditional ...