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 = &quot;Note&quot;
End If
Next cell

End Sub

```

Final Result:Â

Exercise Workbook:

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

STEP 1:Â Go toÂ Developer > Code > Visual Basic

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

See also  Print All Comments of a Worksheet Using Macros In Excel

STEP 3:Â Let us test it out!

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

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

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

Â

How to Highlight Min Value in Selection Using Macros In Excel

### HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin