Skip to main content

How to Shade Every Other Row in Microsoft Excel

Staring at text or numerals in columns and rows isn’t exactly easy on the eyes. There are numerous pre-formatted color schemes you could try, or you could just save the hassle of looking through them and elect to color shade alternating lines.

It’s sleek, professional-looking, and a breeze to do with Excel’s built-in tools.

1. Open an Excel workbook

2. Highlight the area you want to apply the effect to. Don’t alternate rows or columns, just highlight an entire area, as shown. 

3. Under the Home tab, click Conditional Formatting. 

4. Select New Rule. 

5. In the Format Style drop-down, choose Classic.  <classic.png>

6. Choose Use a formula to determine which cells to format.

7. Enter the following formula into the appropriate area: =MOD(Row(),2)=1. 

8. Click Format. 

9. Click the Fill tab and select a color. 

10. Click OK. 

11. Click OK once more to apply the formatting.