color

How to apply color banded rows or columns in excel

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

Hello everyone. Welcome to Excel 10 Tutorial. I am a trainer Kazi and in this

quick tutorial I will show you how to apply color to alternate Rows or Columns or

you can say how to apply color banded rows or column in Microsoft Excel. Okay?

so what we are going to do is apply color to every second rows or every

second Columns okay here is the end result so if we apply color banded rows

the result will be like this if we apply color banded columns the result will be

like this and if we apply color banded columns then the result will be like this okay

let's get started. To apply color to every alternate cells in Microsoft Excel

first we have to select the range where we want to apply the color banded rows

first click on the Home tab and go to the conditional formatting click on new

rule and select this one use a formula to determine which cell to format now

write this formula in this formula bar. Okay? The formula will be in the description

just copy it from there. So this this formula is for color banded rows okay

now click on format and select the color I am selecting this one and click OK. Now

click OK again. See? Every alternate Rows has been colored okay now if you want to

apply color banded columns just select this area and I am going to apply color

to every alternate column. Okay? same way. Home tab, conditional formatting, new

rules use a formula to determine which cell to format and the next formula will

be this one again copy it from the description below and paste it here

click on format select the color click OK and ok again so this one is color

banded rows and this one is color banded columns if you want to use both of them