How to Shade Every Other Row in Microsoft Excel

  • MORE

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.

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

  1. Open an Excel workbook
    new_shade
  2. Highlight the area you want to apply the effect to. Don’t alternate rows or columns, just highlight an entire area, as shown. 
    highlight_shade
  3. Under the Home tab, click Conditional Formatting. 
    conditional
  4. Select New Rule. 
    new-rule
  5. In the Format Style drop-down, choose Classic.  <classic.png>
  6. Choose Use a formula to determine which cells to format.
    use-formula
  7. Enter the following formula into the appropriate area: =MOD(Row(),2)=1. 
    formula
  8. Click Format. 
    format
  9. Click the Fill tab and select a color. 
    color
  10. Click OK. 
    ok_shade
  11. Click OK once more to apply the formatting. 
    ok2_shade
Add a comment