How to Apply Colour to Alternate Rows in Excel (Colour Banding)

Colour banding is a good way to make it easy for readers to scan through a long list. For example, perusing through the list of the recently released UNEB UCE results can be a daunting task if this kind of formatting wasn’t used. Sometimes you will read through a list and fail to see the school of your choice only to be told that it exists on a particular page.

In another example, after a rigorous selection exercise, universities display a list of successful students for a particular year’s intake. Going thru this list would be a nightmare for many if colour banding wasn’t employed.

But how can this done in Ms. Excel? In this article, I share the steps I use to fulfil the task in Ms. Excel 2016.

1.         Select the area whose rows you wish to apply colour banding.

2.         Go to Conditional Formatting and choose New Rule.

3.         Choose Use a formula to determine which cells to format. In the empty area type the formula =MOD(ROW(),2)=0 and then click Format.

4.         Select the Fill tab and choose a colour of your choice then OK and OK again. In my case, I prefer green. You end up with green  alternating colour bands in your selection.

Stephen Dumba
E-zone School of Computing
0772 111 223 / 0752 111 223

This post was last modified on February 6, 2019 12:05 pm

Stephen Dumba

Published by
Stephen Dumba

Recent Posts

OS-POS system is a web based point of sale system build in PHP language. It uses MySQL as the data storage back-end and has a friendly UI.

The main features are: Stock management (Items and Kits)VAT, customer and multi tiers taxationSale register with transactions loggingQuotation and invoicingExpenses…

2 hours ago

How to bypass Windows 7,8 &10 Admin Password using CMD and Windows CD

How to Remove Windows Admin Password without using any software. As ICT teachers, many times we face a challenge of…

1 week ago

How to Download YouTube Videos the Easy Way

YouTube is arguably the world’s biggest and best video sharing site on the internet. If you needed a video of…

1 week ago

ICT Teachers’ Contribution to the General Academic Performance in Schools – The Challenge for the Teacher

In the recent days, there has been a great deal for Uganda Certificate of Education Examinations Results release. We have…

1 week ago

How to Pass an Aptitude Test

As we end the week, the whatsapp groups of the ICT Teachers Association of Uganda where abuzz with requests for…

1 week ago

What To Consider When Purchasing A Smart Phone

As the world goes more digital modern devices continue to evolve with various specifications. Some are original and strong devices…

1 week ago