9th August, 2021

How to alternate row colours in Excel

Author:

Stuart B

Building Websites since 1998

Back to Tutorials main page

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. In this case we will format 5 rows.

Screen shot of how to insert an Excel formula part one

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

Screen shot of how to insert an Excel formula part two

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

Screen shot of how to insert an Excel formula part three

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

Screen shot of how to insert an Excel formula part four

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

Screen shot of how to insert an Excel formula part five

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

Screen shot of how to insert an Excel formula part six

I hope that this simple solution helps you out.