IT Support & Managed Services
Web Design
Cyber Security


February 11, 2021

How to apply colour to alternate rows on Excel

This is a quick guide to add structure and ease of reading to any spreadsheet that you might be struggling to decipher.

Have you ever made or received a spreadsheet and you shuddered at the lack of clarity and wondered how can I make this look cleaner and easier to read? Fear not as I have come across a nice trick to help you add clarity by applying colors to alternate rows in your spreadsheets. Here's how:

  1. Select the range of cells that you want to format.
  2. Click Home and go to Conditional Formatting.
  3. Select new rule
  4. Choose Use a formula to determine which cells to format.
  5. Enter the following formula into the appropriate area: =MOD(Row(),2)=1, then click format
  6. Click the Fill tab and select a color, the select ok
  7. Click OK once more to apply the formatting.

Once you have done this you will be presented with an easy to read spreadsheet.

Here are some before and after screenshots:

Spreadsheet before applied rule
Spreadsheet after the new rule has been applied

Click here to download your free copy of the cyber security e-book mentioned above

If you think this could help someone you know, share it with them!

Need some help? Get in touch...

a: First Floor Suite, Shire Hall, High Pavement, Nottingham, NG1 1HN
p: 0333 090 4793
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form. Please try again.
Copyright © 2021 ARVITENI. All rights reserved. ARVITENI is a company registered in England and Wales with Company Number: 12255133
VAT: 340921227

Website designed by Ourselves