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