Searching for values within a range

I have what im pretty sure is a pretty simple problem to fix. Hoping someone might be able to help.

I have 9000+ cells all with ranges some of which have over lapping ranges in them such as this:

Untitled.png
My question is this:

Is there a way to bring up everything with the value of "39" in the cells range?

Sorry if anything sounds convlouted this is my first time asking for help on a forum.

Thanks for the help guys.

Describe it with sample workbook please? and the desired result of course

Sub Select_Select()
Dim rngFind As Range
    Dim strValueToPick As String
    Dim rngPicked As Range
    Dim rngLook As Range
    Dim strFirstAddress As String
    
'Select all cells
    Cells.Select

'We will be searching in the active selection    
    Set rngLook = Selection

'We are looking for 39
'Replace xlwhole with xlpart if you do not want exact match

    strValueToPick = "39"
    With rngLook
        Set rngFind = .Find(strValueToPick, .Cells(1, 1), LookIn:=xlValues, lookat:=xlWhole)
        If Not rngFind Is Nothing Then
            strFirstAddress = rngFind.Address
            Set rngPicked = rngFind
            Do
                Set rngPicked = Union(rngPicked, rngFind)
                Set rngFind = .FindNext(rngFind)
            Loop While Not rngFind Is Nothing And rngFind.Address <> strFirstAddress
        End If
    End With

'this selects the cells    
    If Not rngPicked Is Nothing Then
        rngPicked.Select
    End If

End Sub

I can select every cell with 39 in it.

The question is do you want exact matches only?

Do you want to select the whole row or specific cells

Having selected them what do you want to do ?

Originally Posted by mehmetcik

I can select every cell with 39 in it.

The question is do you want exact matches only?

Do you want to select the whole row or specific cells

Having selected them what do you want to do ?

I would like to bring up everything that contains a certain value. Looking for x would bring up anything containing or equaling x.

The selection of the whole row is what im looking to bring up and find.

All i need to do is to find them in the sheet.

Bring up how?

With conditional formatting:

format in range.xlsx

Originally Posted by daffodil11

Bring up how?

With conditional formatting:

Attachment 274657

Thats actually extremly close to what im looking for. how exactly would i be able to do that for a column of ranges instead of a table?

Originally Posted by daffodil11

Bring up how?

With conditional formatting:

Attachment 274657

Thanks so much guys, i was just saved hours of research. I managed to adopt this formatting into my sheet and it worked axactly as desired!

THANKS :D