Excel: Shade Every Other Row
Coloring every other row in an Excel document makes it more readable. Rather than coloring each row individually, use the following instructions to quickly perform this task.
- Under the Home tab in the ribbon, click "Format as Table" in the Styles section.
- Select the preset style that best fits your information.
- When the "Format as Table" box opens, make sure that all your information is selected > Press [OK].
- Use your mouse to highlight the range of cells that require conditional formatting.
- Go to the "Home" tab > Locate the "Styles" group > Choose the "Conditional Formatting" option.
- Choose "New Rule...." > Select "Use a formula to determine which cells to format."
- Under "Format values where this formula is true:" enter: =MOD(ROW(),2)=1.
- Click [Format…] > Choose the "Fill" tab > Choose a color. (The lightest gray or pale yellow are generally best when printing.)
- Click [OK] > Click [OK].
Keywords: every other, rows, color, light, dark, shade, shading, color, coloring, grey, gray, yellow, readability, read, easy, easier