Shading Rows with Conditional Formatting in Excel

Conditional formatting allows you to add special formatting options to specific areas of a worksheet.

One of these options is to shade alternate rows of data in a worksheet.

Shading alternate rows makes it easier to read across long rows of data, and while it is easy enough to do manually for a small worksheet; it can be a real chore when trying to do it for larger ones.

Using conditional formatting not only makes it easier to accomplish this task, but it is easy to modify the shaded range in case you later make changes to your worksheet.

To find out all the details, read the tutorial on Shading Rows with Conditional Formatting in Excel.

Related Tutorials

• Conditional Formatting Dates in Excel
• Find Duplicate Data in Excel with Conditional Formatting
• Excel 2003 Conditional Formatting