Hi, for your Conditional formatting, which is so much easier!, highlight all the cells you want have included in the range, click on Format, Conditional Formatting, you need to choose Cell Value Is, then click Equal To then in the one remaining box type promise (no inverted comas needed, no need to type a capital), then choose your format (colour), click ok, you should now find every cell in your range that contains the word promise will be your chosen colour!

HTH

Simon