As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Alternating Brilliance: A Guide on How to Highlight Every Other Row in Excel

Applying alternating row colors in Excel enhances readability and makes large datasets easier to navigate. This guide will walk you through the steps to highlight every other row, providing a visually appealing and organized structure to your spreadsheet.

Step 1: Open Your Excel Spreadsheet

1.1 Launch Microsoft Excel and open the spreadsheet where you want to highlight every other row.

Step 2: Select the Range of Rows

2.1 Click on the row number on the left-hand side to select the entire row.2.2 Drag to select the range of rows you want to apply alternating colors to.

Step 3: Go to the "Home" Tab

3.1 Navigate to the "Home" tab in the Excel ribbon.

Step 4: Use Conditional Formatting

4.1 Click on "Conditional Formatting" in the Excel ribbon.

Step 5: Choose "New Rule"

5.1 In the dropdown menu, choose "New Rule."

Step 6: Select a Rule Type

6.1 Choose "Use a formula to determine which cells to format."

Step 7: Enter the Formula

7.1 Enter the formula to determine if the row is even or odd. For example, if you selected rows 2 to 100, enter the formula:


Step 8: Configure the Format

8.1 Click on "Format" to choose the fill color for the alternating rows.8.2 Click "OK" to confirm the format.

Step 9: Click "OK" in the New Formatting Rule Dialog

9.1 After setting up the rule and format, click "OK" in the "New Formatting Rule" dialog box.

Step 10: Test and Review

10.1 Verify that every other row in the selected range is now highlighted with the specified format.

Additional Tips:

  • Modify the Formula:
  • Adjust the formula based on your selected range. For example, if you start from a different row or have a different number of rows, modify the formula accordingly.
  • Use Built-in Alternating Row Colors:
  • In Excel tables (Insert > Table), alternating row colors are applied automatically. Consider converting your data to a table for easy alternating row formatting.


Highlighting every other row in Excel improves the readability and visual structure of your data. By following these steps, you can efficiently apply alternating row colors using conditional formatting, providing a clear and organized appearance to your spreadsheets. Whether you're working with large datasets, tables, or any other document, alternating row colors contribute to a more user-friendly and visually appealing Excel experience.