How to highlight alternate rows in Excel 2013

Highlighting alternate rows in Excel 2013 worksheet makes the data visually much more appealing. Instead of doing this manually, we can use Conditional Formatting feature to automatically shade every other row in Excel.

Conditional Formatting gives us flexibility to change the shade colour in case it is required. The biggest advantage of using Conditional Formatting is that the shading is dynamic i.e. it automatically updates if we insert or delete the rows.

Also read: How to Trace Precedents and Dependents in Excel 2013

Below steps will help you highlight alternate rows:

1. Select the data range where we want to highlight alternate rows.
   

2. Go to "HOME" tab >>> Conditional Formatting >>> Click "New Rule..."
   

3. This will open conditional formatting dialog box. Click "Use a formula to determine which cells to format"

4. Enter the formula =MOD(ROW(), 2)
   

5. Click on "Format" button and choose the shade or format for alternate rows
   

6. Click OK >> OK and you will see that alternate rows in selected data range are shaded as per desired format (here with GREEN fill)
   

More interesting articles on this website:

• How to use AGGREGATE function in Excel 2013
• Two Way lookup in Excel 2013 using INDEX and MATCH
• How to create Histogram in Excel 2013
• How to create Waterfall Chart in Excel 2013