How to apply color banded rows or columns in excel

How to apply color banded rows or columns on excel or how you can color or shade every alternate rows or columns in excel. Yes. This is what you are going to learn today. Welcome to excel 10 tutorial and lets get started.

Color Banded Rows: Color banded rows indicate every second/alternate rows with color/shading.To attain this you'll have to use conditional formatting. Lets follow the below procedure to color every alternate rows.

Step 1: Select the cell ranges where you want to apply color.
Step 2: In the home tab click on conditional formatting.
Step 3: Select "New Rule"
Step 4: Select "Use formula to determine which cells to format"
Step 5: Paste this formula in the formula bar for coloring every alternate rows.
=MOD(ROW(),2)=0
Step 6: Click "Format" and select "Fill"
Step 7: Select the color and click ok and ok again.
Done you have successfully color banded excel rows.

Color Banded Columns: Color banded columns indicate every second/alternate columns with color/shading.To attain this you'll have to use conditional formatting. Lets follow the below procedure to color every alternate columns.

Step 1: Select the cell ranges where you want to apply color.
Step 2: In the home tab click on conditional formatting.
Step 3: Select "New Rule"
Step 4: Select "Use formula to determine which cells to format"
Step 5: Paste this formula in the formula bar for coloring every alternate columns.
=MOD(COLUMN(),2)=0

Step 6: Click "Format" and select "Fill"
Step 7: Select the color and click ok and ok again.
Done you have successfully color banded excel columns.

Thanks for watching.
#Color #AlternateRow
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ

Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
Excel VBA Programming Course: bit.ly/excelvbacourse

Social media:
Facebook: facebook.com/excel10tutorial
Twitter: twitter.com/excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: excel10tutorial.tumblr.com
Instagram: instagram.com/excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial *Become a member and enjoy exclusive perks while supporting the channel you love!*
youtube.com/@Excel10tutorial/join