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

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 ?

Please Login or Register  to view this content.

Bring up how?

With conditional formatting:

format in range.xlsx

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.

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