Wanted to find the minimum value in a range of values? Excel Macros can easily highlight the min value in your selection for you!

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 the smallest value in your selection

Copy Source Code:


Sub HighlightMinValue()

Dim cell As Range
For Each cell In Selection

'If it matches the smallest value, then change the style to be Note
If cell = WorksheetFunction.Min(Selection) Then
cell.Style = "Note"
End If
Next cell

End Sub

Final Result: 

Highlight Min Value in Selection Using Macros In Excel | MyExcelOnline

Exercise Workbook:

Highlight Min Value in Selection Using Macros In Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK


These are our set of values, let us go find the smallest one!

Highlight Min Value in Selection Using Macros In Excel | MyExcelOnline

STEP 1: Go to Developer > Code > Visual Basic

Highlight Min Value in Selection Using Macros In Excel | MyExcelOnline

 

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

Highlight Min Value 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 Min Value in Selection Using Macros In Excel | MyExcelOnline

 

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

Highlight Min Value in Selection Using Macros In Excel | MyExcelOnline

 

With just one click, your cell with the smallest value is now highlighted!

 Highlight Min Value in Selection Using Macros In Excel | MyExcelOnline

 

How to Highlight Min Value 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