Alternate row colouring in Excel

Tutorial by Stuart B

Posted Friday, November 5, 2021

Example of abstract graphic design

A simple guide to highlight alternate rows in Excel

In this tutorial I will teach you how to alternate row colours in Excel via a simple formula. Not long ago a friend rang me up. He had to put forward a presentation and just wanted to highlight alternate rows in an Excel spreadsheet so that the data could be seen better via a projection system he was going to use. When I told him how to do it his reply was, "Is that it"?

So I thought that I'd share this really simple tip to get you up and running with this in no time at all.

Step 1. Open up excel and highlight the rows that you wish to add the formula to.

Step 2. On the 'Home' tab click on 'Conditional Formatting'

Step 3. On the 'Options' screen that appears choose 'New Rule' from the list and then type in:
=MOD(ROW(),2)=0 When you have done this go to the 'Format' option button

Step 4. This is where we are going to define the colour of the row.

Step 5. Click on 'OK' and then 'OK' again on the next screen. That's it. You're all done.

With a little styling this is a better example of the finished product.