Highlight part of cell based off another

[earthandbody]

Greetings,

I have a spreadsheet that has one cell filled with values and I want when that same value is entered into another cell to only highlight that same text and not the entire cell.

In the sample attached B2 had the multiple values. Cell C5 has the one value that matches one in cell B5 that I would like to be highlighted.

Thanks in advance,
Jess

[JohnTopley]

Mis-undertood: solved elsewhere?

[azumi]

Try this step called Conditional Formatting:
1. select C5
2. click on "Home" tab
3. click on "Conditional FOrmatting" button and select "New Rules..." option by click it
4. And "New Formatting Rule" box will showed up
5. And "Select a Rule Type" on "Use a formula to determine which cells to format"
6. Put this formula on "Format values where this formula is true:" =OR(ISNUMBER(SEARCH(TRIM(MID(SUBSTITUTE(C5," ",REPT(" ",99)),1+99*(ROW(OFFSET($A$1,,,1+LEN(C5)-LEN(SUBSTITUTE(C5," ",""))))-1),99)),$B$1)))
7. don't forget to choose how to format the cells by click on "Format" button
8. Last step copy the format with "Format Painter" button on "Home" tab

Hope my self clear, if still doesn't work check the file in attachment