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.
- Open an Excel workbook.
- Highlight the area you want to apply the effect to. Don’t alternate rows or columns, just highlight an entire area, as shown.
- Under the Home tab, click Conditional Formatting.
- Select New Rule.
- In the Format Style drop-down, choose Classic. <classic.png>
- Choose Use a formula to determine which cells to format.
- Enter the following formula into the appropriate area: =MOD(Row(),2)=1.
- Click Format.
- Click the Fill tab and select a color.
- Click OK.
- Click OK once more to apply the formatting.
- 10 Excel Business Tips You Need to Keep Your Job
- How to Use Microsoft Outlook Like a Pro
- 10 Microsoft Word Tips That Will Save Your Job