Conditional formating

[TMac52]

I have a cell with a string of text. I need to select 3 words of that text and format it per my selection. Example: bolt, stud, 1/2", A193, B7, ATS.
Pick out bolt, stud, 1/2 & B7 and format these cells red letters & yellow fill.
The size & grade (B7) will change as needed per size & grade needed.

 

[TMac52]

Good morning JoeMo. Just getting back to this.
I entered the formula attached and I'm pretty sure it's exactly as yours - maybe I'm not seeing something? Is the 1/2 piece throwing it off?
=AND(ISNUMBER(SEARCH("Bolt",C2)),ISNUMBER(SEARCH("stud",C2)),ISNUMBER(SEARCH("1/2",C2)),ISNUMBER(SEARCH("B7",C2)))

 

[TMac52]

Hello again JoeMo. I don't know what I did, but it is working as you said now. The only thing I can figure is when I closed my file without saving, it cleared out something that was holding on to previous formatting. Anyway, thanks to you again. I really appreciate your support! Hope you have a great day.

 

[Peter_SSs]

=AND(ISNUMBER(SEARCH("Bolt",C2)),ISNUMBER(SEARCH("stud",C2)),ISNUMBER(SEARCH("1/2",C2)),ISNUMBER(SEARCH("B7",C2)))

If that CF formula is doing what you want, then I believe this considerably shorter one will too.

=SEARCH("Bolt",C2)+SEARCH("stud",C2)+SEARCH("1/2",C2)+SEARCH("B7",C2)

 

[JoeMo]

Hello again JoeMo. I don't know what I did, but it is working as you said now. The only thing I can figure is when I closed my file without saving, it cleared out something that was holding on to previous formatting. Anyway, thanks to you again. I really appreciate your support! Hope you have a great day.

Glad you got it sorted out.