Excel Highlight Row

Highlight Every Other Row in Excel using Conditional Formatting

When your table is huge, it is easier to read the data when every other row are filled with different colors. In this example, we will demonstrate how to fill colors alternately. This trick can also highlight every third row in Excel (4th row, 5th row and so on).
Highlight Every Other Row in Excel

How is it done
Step 1. Select the Excel data.
Highlight Every Other Row in Excel 2

Step 2. Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. See screenshot below for details.
Conditional Formatting in Excel 3

Step 3. Type in the formula =mod(row(),2)=0 (as shown below). Then press 'Format..', new small window will pop out, click 'Fill' tab. Select the desired color (in this example we chose green), press 'OK'.
Highlight Every Other Row in Excel 4

There is another way to fill colors in sequence, this can be done using our multi-tool add-in. The colors set by this add-in are applied to the cells directly (not through conditional formatting), this means the color will stay when you delete row/rows.
Show Comments

About Us

Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.

© Copyright 2023 Excelcrib | Privacy Policy

We use cookies to improve your browsing experience.
Continuing to use this site means you agree to our use of cookies.
Tell me more!