Highlight Every Other Row

highlight1In Excel, just as in life, sometimes you want to set your data apart by highlighting every other row a certain color. You can do it manually, but that would be silly. Keep reading to see how you can perform this task in less than 15 seconds.

Let’s say you have the following set of data.
highlight 2

Highlight the area where you want to apply the formatting (A2:C9) and go to Conditional Formatting on the Home tab and select New Rule.

highlight3

Under “Select a Rule Type:” click “Use a formula to determine which cells to format”. Type in the following formula: =MOD(ROW(),2)=1

highlight4

Click the Format button, go to the Fill tab, choose your color you want to use as the highlight and click Ok

highlight5

Next hit Ok on the New Format menu and BOOM! You have mastered the art of highlighting every other row. Now, go show this to your kids and see how amazing they think you are.

highlight6