Shading Rows with Conditional Formatting in Excel
For more Excel tips and tricks go to my static page: Excel Tutorials and Tricks Series.
Conditional formatting can be used for shade alternate rows in a selected range of data. In large worksheets, shading alternate rows makes it easier to read data from left to right across the worksheet .
Example: Shading Rows with Conditional Formatting in Excel 2007Note: For help with this example, see the image above.
- Open an Excel worksheet - a blank worksheet will work for this tutorial.
- Drag select cells A1 to H10 to highlight them.
- Click on the Home tab.
- Click on the Conditional Formatting icon on the ribbon to open the drop down menu.
- Choose New Rule option to open the New Formatting Rule dialog box.
- Click on the Use a Formula to determine which cells to format option from the list at the top of the dialog box.
- Enter the following formula in to the box below the Format values where this value is true option in the bottom half of the dialog box .
=MOD( ROW( ), 2) =0
- Click the Format button to open the Format Cells dialog box.
- Click the Fill tab to see the background color options.
- Select a color to use for shading the alternate rows of the selected range.
- Click OK twice to close the dialog box and return to the worksheet.
- Alternate rows in the selected range should now be shaded with the chosen background fill color.