Having a heck of a problem figuring this one out. Any help would be appreciated.
Here is what I am trying to accomplish:

Cell A1 has text. The text contains 1 of 6 phrases (STRICT SHORT, STRICT LONG, MID OCO SHORT, MID OCO LONG, OUTSIDER L2 SHORT, or OUTSIDER L2 LONG).

I am trying to get B1 to be conditionally formatted to change color only when A1 contains the phrase "OCO" - essentially changing the color of B1 only when the phrase "MID OCO SHORT" or "MID OCO LONG" appears in A1. I think you could write the formula multiple ways. You could use multiple IF statements, or you could search for *OCO* within the phrase. I can't get either one to work because I must be writing this wrong. Either way, the most efficient formula is preferred! Any help would be much appreciated.