VBA code that you can use to highlight the minimum value in a range in Excel.
VBA Code:
Sub HighlightMinValue()
Dim rng As Range
Dim cell As Range
Dim minVal As Double
' Set the range where you want to find the minimum value
Set rng = Range("A1:D10")
' Initialize minVal with the maximum possible value
minVal = 1E+20
' Find the minimum value in the range
For Each cell In rng
If IsNumeric(cell.Value) Then
If cell.Value < minVal Then
minVal = cell.Value
End If
End If
Next cell
' Highlight the cell(s) with the minimum value
For Each cell In rng
If cell.Value = minVal Then
cell.Interior.Color = RGB(255, 255, 0)
End If
Next cell
' Inform the user that the highlighting is complete
MsgBox "The cell(s) with the minimum value have been highlighted!"
End Sub
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
