Pinterest Pixel

Highlight Alternate Rows in Selection Using Macros In Excel

When it comes to highlighting alternate rows in your data, it’s a cumbersome process! One way is... read more

Download Excel Workbook
Bryan
Posted on

Overview

Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline

When it comes to highlighting alternate rows in your data, it’s a cumbersome process! One way is to use the table formatting option in Excel, but you can also use Excel Macros to highlight alternate rows for you!

And you have full control on how it will look like!

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Highlights alternate rows in your selection

Copy Source Code:


Sub HighlightAlternateRowsInSelection()

Dim range As Range
For Each range In Selection.Rows

'Check if it's the alternate row by using modulo, set it to the style of note
If range.Row Mod 2 = 1 Then
range.Style = "Note"
Else
End If

Next range
End Sub

Final Result: 

Highlight Alternate Rows in Selection Using Macros In Excel

Exercise Workbook:

Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline

Download excel workbookHighlight-Alternate-Rows-in-Selection.xlsm


Here is our initial set of data:

Highlight Alternate Rows in Selection Using Macros In Excel

STEP 1: Go to Developer > Code > Visual Basic

Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline

 

STEP 2: Paste in your code and Select Save. Close the window afterwards.

See also  Free Excel Macros & VBA Webinar Training

Highlight Alternate Rows in Selection Using Macros In Excel

 

STEP 3: Let us test it out!

Open the sheet containing the data. Go to Developer > Code > Macros

Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline

 

Make sure your data and macro are selected. Click Run.

Highlight Alternate Rows in Selection Using Macros In Excel

With just one click, the alternate rows of your selection are now highlighted!

Highlight Alternate Rows in Selection Using Macros In Excel

 How to Highlight Alternate Rows in Selection Using Macros In Excel

 

101 Macros Book

If you like this Excel tip, please share it
Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline Highlight Alternate Rows in Selection Using Macros In Excel | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...