How To Make Every Other Row Shaded In Excel

Apply conditional formatting to the cells in every other row to make them shaded in Excel.

Excel is a versatile and powerful tool that is widely used for organizing and analyzing data. It offers a wide range of formatting options to make your spreadsheets visually appealing and easy to read. One commonly desired formatting technique is to shade alternate rows, which not only enhances readability but also gives the data a more polished look. In this blog post, we will guide you through the step-by-step process of making every other row shaded in Excel, saving you time and effort in manually formatting large datasets. Whether you are a beginner or an experienced Excel user, this tutorial will equip you with the knowledge and skills to effectively apply this formatting technique to your spreadsheets. So let’s dive in and learn how to make every other row shaded in Excel.

How To Make Every Other Row Shaded In Excel: Step-by-Step


Step 1: Open Excel Worksheet,

To begin, launch Microsoft Excel and open the desired worksheet where you would like to implement alternating shading. This feature allows you to easily differentiate and highlight rows or columns in your data for better readability and organization.

Next Step

Step 2: Select data,

Select all the cells where you want this visual enhancement or modification to occur on a spreadsheet or document. This will ensure that the desired effect is applied uniformly to the selected areas.

Next Step

Step 3: Accessing Conditional Formatting,

To access ‘Conditional Formatting’, navigate to the ‘Home’ tab and locate the ‘Styles’ group. From there, simply click on it to open the options.

Next Step

Step 4: New Rule,

In the drop-down list of ‘Conditional Formatting’, select ‘New Rule’ to create a custom rule for formatting cells based on specific criteria or conditions.

Next Step

Step 5: Select a Rule Type,

In the ‘New Formatting Rule’ window, choose the option ‘Use a formula to determine which cells to format’. This allows you to apply formatting based on specific conditions or criteria defined by a formula.

Next Step

Step 6: Enter Formula,

This formula, =MOD(ROW(),2)=1, is used to format values where it evaluates to TRUE for every other row starting from the first.

Next Step

Step 7: Format settings,

Click on the ‘Format’ button, located directly below the formula box, to access a range of formatting options for your document, allowing you to customize its appearance and make it more visually appealing.

Next Step

Step 8: Choose formatting style,

In the ‘Format Cells’ window, navigate to the ‘Fill’ tab and select the desired color for shading. Lastly, click ‘OK’ to apply the chosen color for shading.

Next Step

Step 9: Apply Format,

Once you have set the desired formatting rule, click ‘OK’ in the ‘New Formatting Rule’ window to effectively apply the formatting to the selected cells.

Next Step

Step 10: Result,

The worksheet displays an alternate shaded pattern that remains consistent even when adding or deleting rows and cells, thanks to the condition specified in the Rule.


In conclusion, shading every other row in Excel can greatly improve the readability and visual appeal of your spreadsheets. By following the simple steps outlined in this blog post, you can easily achieve this professional-looking effect. Whether you are creating financial reports, organizing data, or simply working on a project, making use of alternating row shading can make your Excel sheets easier to navigate and understand at a glance. So go ahead and give it a try – your eyes will thank you for it!

Table of Contents