Shade row based on text CONTAINED in first cell of row

[Kimber]

This seems like a simple formula but I did not find another post addressing it. I wish to shade a row based on "CAST" within other text in the first cell of the row. =$B2="CAST" works if it is the only word, but there is a string of text in the cells of the first column. Thank you.

 

[John Jairo V]

Hi, @Kimber !

You could try:
=COUNTIF($B2,"*CAST*")

Blessings!

 

[Kimber]

Hi, @Kimber !

You could try:
=COUNTIF($B2,"*CAST*")

Blessings!

Thank you so very much, John! It worked perfectly!