how to select the cells which have value less than certain number (let's say 100)

[samtheman]

Good Morning Geniuses,
How to select (not highlight) the cells which have value less than certain number (let's say 100)?

Thanking you,

Samtheman

 

[John Jairo V]

Hi @samtheman!

First select the range that you want to verify, and later run this macro:

Sub SelectLessthan100()
  Dim c As Range, R As Range
 
  For Each c In Selection
      If c < 100 Then
        If R Is Nothing Then Set R = c Else Set R = Union(R, c)
      End If
  Next c
 
  R.Select
  Set R = Nothing: Set c = Nothing
End Sub

Blessings!

 

[samtheman]

Thank you very much. Is there a way to do it without any VBA?

 

[John Jairo V]

Hi again @samtheman!

I don't know any method without VBA for make selection with logic conditions instead equals (for example: equals to 100 you could do with Find and Replace).

You can use a Third-Party Add-in like Kutools or something like this... but those add-ins were programmed by VBA.

Blessings!

 

[samtheman]

John,
Thank you for your suggestion

 

[Chief Ace]

Using a helper column

=IF(A1<=100,"YES","NO")