You will be surprised on how much you can do with macros. It can highlight values in your selected range that are greater than a value you specify.

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 values greater than your specified value

Copy Source Code:


Sub HighlightValuesGreaterThan()

'Get the Greater Than Value
Dim value As Long
value = InputBox("Enter Greater Than Value", "Enter Greater Than Value")

Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, Formula1:=value
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority

'Set the font to black and highlighting color as yellow
With Selection.FormatConditions(1)
.Font.Color = RGB(0, 0, 0)
.Interior.Color = RGB(255, 255, 0)
End With

End Sub

Final Result: 

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

Exercise Workbook:

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK


These are our values:

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

STEP 1: Go to Developer > Code > Visual Basic

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

 

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

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

 

STEP 3: Let us test it out!

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

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

 

Make sure your data is selected and that your correct macro is selected. Click Run.

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

Enter the greater than value, we will enter 50000. Click OK.

Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

With just one click, all of the values greater than 50000 are now highlighted!

 Highlight Values Greater Than Using Macros In Excel | MyExcelOnline

 

How to Highlight Values Greater Than 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