How to Apply Shading to Every Other Row or Column in Excel

This post will guide you how to apply shading to every other row or column in Excel. How do I shade every other row in Microsoft Excel 2013/2016.

Shade Every Other Row


If you want to share every other row in your current worksheet, you can use a simple conditional formatting formula. Just do the following steps:

Step1: select the range of cells that you want to shade every other row.

apply shade to every other row2

Step2: go to Home tab, click Conditional Formatting command under Styles group, and select New Rule from the dropdown menu list. And the New Formatting Rule dialog will open.

apply shade to every other row1

Step3: In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format, and type the following formula into the Format values where this formula is true text box.

=MOD(ROW(),2)=0

apply shade to every other row3

Step3: click Format button, and the Format Cells dialog will open. swith to Fill tab in the Format Cells dialog box, and Select the background or pattern color that you want to use for the shaded rows. click Ok button to back to New Formatting Rule dialog box.

apply shade to every other row4

apply shade to every other row5

Step4: click OK button, let’ see the last result:

apply shade to every other row6

 

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar