# Highlight Min Value in Selection Using Macros In Excel

Wanted to find the minimum value in a range of values? Excel Macros can easily highlight the... read more

## Overview

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.

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

##### Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Highlight Cells with a Single Space Using Macros In Excel

## 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.