Want to find the values in your list that are unique? It is very easy to do with Excel Macros, you can highlight unique values in your selected range in a click!

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 distinct values in your selection

Copy Source Code:


Sub HighlightUniqueValuesInSelection()

'Set the range as the current selection
Dim range As Range
Set range = Selection
range.FormatConditions.Delete

'Color the unique values with green
Dim uniqueVals As UniqueValues
Set uniqueVals = range.FormatConditions.AddUniqueValues
uniqueVals.DupeUnique = xlUnique
uniqueVals.Interior.Color = RGB(0, 255, 0)

End Sub

Final Result: 

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

Exercise Workbook:

DOWNLOAD EXCEL WORKBOOK

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline


Here is our initial set of data:

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

STEP 1: Go to Developer > Code > Visual Basic

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

 

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

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

 

STEP 3: Let us test it out!

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

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

 

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

Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

 

With just one click, all of the unique values are now highlighted!

 Highlight Unique Values in Selection Using Macros In Excel | MyExcelOnline

 

How to Highlight Unique Values in Selection Using Macros In Excel

HELPFUL RESOURCE:

101 Macros Book

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn