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

How to Test a Computer’s Power Supply

In the years that I have repaired computers, it’s on only a handful of occasions that I find the power…

3 hours ago

How to Install Windows XP, Step by Step

Almost all the times I install Windows OS on a PC, its either Windows 7 or Windows 10. However, on…

2 days ago

How To Disable A Computer’s USB Ports

This year, I was given the privilege to install NComputing in the computer lab of St. Aloysious Senior Secondary School…

6 days ago

UNEB reports to be discussed during upcoming Budo workshop

UNEB releases Reports on Candidates Work hoping that teachers in schools will find the information useful, and that it creates…

3 weeks ago

Future Code Club inspiring teens to code and get creative with technology

Future Code Club is a nonprofit initiative dedicated to providing teens between ages 9 to 18 years access to computer…

2 months ago

Why your school needs E-SchoolPlus

In modern world, where every sector is being modified by advanced technologies, how can education can remain untouched? This is…

2 months ago