how to shade every other row in excel for mac

This lesson shows you a quick and easy way to do it on Excel 2011 for Mac.

The way it works is to check to see if the current row number is an even number, and then format the even numbered rows with a formatting colourshading of your choice.

It is a bit convoluted, but works well once you follow these steps.

In our case, we are skipping the presets (the first five options) and setting up a New Rule.

Note that you can also choose Conditional Formatting from the Format menu.

Click OK once more to see how the selected cells look once the rule is applied.

Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience.

Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through.

I repeat - we delete all spam, and if we see repeated posts from a given IP address, well block the IP address.

One other point to note - if you post a link in your comment, it will automatically be deleted.

You would think Microsoft would just make this a one click option.

Note that for anyone using an older version of Excel (before Excel 2007) the ISEVEN function isnt supported.

Web page addresses and e-mail addresses turn into links automatically.

Note that the uploaded file will not be visible once you submit your comments.

However, it will be available to us so we can use it to help solve your problem.

Website development and content by Millionleaves.com.

View our Privacy Policy.

How To Shade Every Other Row In Excel For Mac