Microsoft Excel how to select all cells that meet certain condition (i.e greater than a value)

Question

I am using Microsoft Excel 2013, and I want to select all cells that contain the value that is greater than a value. How do I do this ?

I have tried using Go To Specials, but it seems it is only able to select cells that have certain property such as blanks, have formulas or visible cells.

I have also found Microsoft Excel extension such as Ablebits, but it needs to pay, and I prefer the default function from excel.

Thankyou in advance.

Answer 1

One way is to run through all the data with a small macro.

Sub clean()
Dim r As Range, i As Integer
Set r = Range("A1:AE150")
Application.ScreenUpdating = False
Do
    i = 0
    For Each cell In r
        If cell.Value >150000 Then
            cell.Delete Shift:=xlUp
            i = i + 1
        End If
    Next cell
Loop While i > 0
Application.ScreenUpdating = True
End Sub

Warning
The actions of a macro cannot be undone. Always save before running it to prevent the loss of data.

Note that this macro will fail if there are Tables involved