Condtional format a cell based on text found in another cell

[alexransome]

Hi,

Column K has the numbers I'd like to highlight RED if "...STO-R..." in column J, or BLUE if "...STO-B..." appears in column J.

Many thanks for any help.

 

[Special-K99]

Select K1

Conditional Formatting
New Rule
Use a formula to determine...
2 formulas needed

=(NOT(ISERROR(SEARCH("STO-R",K1))))
format as red

=(NOT(ISERROR(SEARCH("STO-B",K1))))
format as blue

Use Format painter (paintbrush icon) to copy to other cells