Written by Allen Wyatt (last updated January 18, 2022)
This tip applies to Excel 97, 2000, 2002, and 2003
If you haven't tried out the conditional formatting features of Excel before, they can be quite handy. One way to use this feature is to cause Excel to shade every other row in a table. This is great when you have a particularly wide table, and you want to make it a bit easier to read on printouts. Simply follow these steps:
Figure 1. The Conditional Formatting dialog box.
=MOD(ROW(),2)=0
Figure 2. The Patterns tab of the Format Cells dialog box.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2799) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Shading Rows with Conditional Formatting.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
If an error exists in a formula tucked inside a conditional format, you may never know it is there. There are ways to ...
Discover MoreIf you have conditional formatting applied in a worksheet, the formulas in those formats may not be as secure as you ...
Discover MoreConditional formatting is a great feature in Excel. Here's how you can copy conditional formats from one cell to another ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments