Highlight Every Other Row in Excel using Conditional Formatting
How is it done
Step 1. Select the Excel data.
Step 2. Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. See screenshot below for details.
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'.
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.
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.