Highlighting or shading every other row in Excel is a great way to make your data easier to read. I’ll show three methods for applying color to alternate rows. Method 1 is my least favorite, but I see users doing this a lot. Method 2 is one of my favorite features in Excel, but for the most control, use method 3. Method 3 is Conditional Formatting and I use the MOD Function and the ROW function. The MOD function returns the remainder of one number divided by another. The ROW function tells you what row you are in.

MOD Examples:
=MOD(7,2) will return 1. Seven divided by 2 is 3 with 1 remaining.
=MOD(7,3) will return 1. Seven divided by 3 is 2 with 1 remaining.
=MOD(7,4) will return 3. Seven divided by 4 is 1 with 3 remaining.
=MOD(4,2) will return 0. Four divided by 2 is 2 with 0 remaining.

ROW Examples:
=ROW(A7) will return 7
=ROW(D6) will return 6.
=ROW() will return 3, if you are in row 3 will return 3.

Chapters:
00:00 Introduction
00:22 Method 1
00:47 Method 2
01:27 Method 3
05:27 Closing

Blog post – https://chrismenardtraining.com/post/excel-3-methods-to-shade-every-other-row

And make sure you subscribe to my channel!

— EQUIPMENT USED ———————————
○ My camera – https://amzn.to/3vdgF5E
○ Microphone – https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights – https://amzn.to/3vaxyy5
○ Dual monitor mount stand – https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount – https://amzn.to/3g96FGj
○ Boom Arm – https://amzn.to/3g8cNi6

— SOFTWARE USED ———————————
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Please take the opportunity to connect and share this video with your friends and family if you find it useful.