Highlight Every Other Row in a Selection in Excel - Table Formatting

This free Excel macro will highlight every other row in a selection of cells with a color that is specified within the macro. To use this macro, you must first select a range of cells or a table in Excel and then run the macro. From there, the first row and then every other row will have a background color. This allows you to easily navigate large tables and more clearly present information in Excel.

To change the color that the rows will change to, just change the number at the end of this line within the macro:

Selection.Rows(r).Interior.ColorIndex = 37

The number at the end of the row above is a color index number for Excel.

Where to install the macro:  Module

Excel Macro to Highlight Every Other Row in a Selection in Excel - Table Formatting

Sub Highlight_Every_Other_Row()
'This macro highlights every other row within a selection of rows - you select the table/rows you want formatted

Dim r As Integer

For r = 1 To Selection.Rows.Count
 If r Mod 2 = 1 Then
  Selection.Rows(r).Interior.ColorIndex = 37
 End If
Next

End Sub

---