hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks