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/...

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!