HDTutorial
EN
How to Shade Alternate Rows in Excel Mac OS X

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Shade Alternate Rows in Excel Mac OS X

9,028 views October 27, 2015 2:30

Watch on YouTube
ChannelHow To Liveable

Description from the creator

To shade alternate rows in Excel Mac OS X:
- Open up your Excel document and highlight all your data
- Go to Format toolbar, select Conditional Formatting and it will open up a text box
- Click on Cell Value Is and select Formula Is
- Type in the formula =row()=even(row()) and click format
- This formula is telling Excel that it wants the row number to equal and even row numbers
- Click Patterns, select gray for the cell shading color (you can change the font, border, patterns)
- Click OK and you will see that all the even number rows have are now color gray
- You can also change it to odd numbers

Added resource on how to shade alternate rows in Excel Mac OS X:
From: groovypost.com/howto/alternate-color-between-ro…

About this tutorial

How To Liveable published this 2:30 video tutorial on October 27, 2015. It has been watched 9,028 times on YouTube.

Duration
2:30
Published
October 27, 2015
Views
9,028
Likes
30

Tags

Share

This tutorial in other languages