How to apply color banded rows or columns in excel

Published: 28 August 2019
on channel: Excel 10 tutorial
290,998
2.1k

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
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

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

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial  


Watch video How to apply color banded rows or columns in excel online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 28 August 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 290,998 once and liked it 2.1 thousand people.