VBA code that you can use to highlight the maximum value in a range in Excel.
VBA Code:
Sub HighlightMaxValue()
Dim rng As Range
Dim cell As Range
Dim maxVal As Double
' Set the range where you want to find the maximum value
Set rng = Range("A1:D10")
' Initialize maxVal with the minimum possible value
maxVal = -1E+20
' Find the maximum value in the range
For Each cell In rng
If IsNumeric(cell.Value) Then
If cell.Value > maxVal Then
maxVal = cell.Value
End If
End If
Next cell
' Highlight the cell(s) with the maximum value
For Each cell In rng
If cell.Value = maxVal 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 maximum 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.
