Can a Conditional Formula highlight cell G2 in range (G1:H2) that contains value 32? Where two cells values are combined into one cell?

[arthurz11]

 

[dreid1011]

Sorry for the very late reply. It's even more frustrated trying to solve it and just having a tooth extracted. (for real). Just got back from the dentist. Anyway, I removed the text (letters) from the cells so I can explain myself more clearly. I used only numeric values. I just want to highlight the number 3 (“first value” before the hyphen) Or just want to highlight the number 32 (“first value” before the hyphen) Please view the image.

View attachment 116036

Theoretically, Fluff's formula should be handling that just fine then. In practice, there may be something else in the cells that is throwing it off?

 

[Fluff]

As you can see in post#8, the formula I suggested does what you've asked for.
If it is not working for you, can you post some sample data that shows the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[arthurz11]

=ISNUMBER(SEARCH(" 32-"," "&G1))

OMG, I had an extra hyphen on my data. Thanks a million!!!

 

[arthurz11]

Theoretically, Fluff's formula should be handling that just fine then. In practice, there may be something else in the cells that is throwing it off?

OMG, I had an extra hyphen on my data. Fluff's formula was correct all along. Anyway, thank you so much for your time.

 

[Fluff]

Glad we could help & thanks for the feedback.