Conditional Format of column, if cell contains *name*

I don't have my think Hat on today. I've been trying to create a 'Conditional Formatting' for an entire column, wherein if a cell within the column contains specific text within the cells text-string, the cell color will change.

Example: (I'm wanting to colorize any cell containing the text 'spare' in column "F" , as in:

Assume all text strings are in column "F";

Transistor - main board
Transistor - main board spares <- should get colorized
Diode - 1N4000
Diode - 1N4000 / spare <-should get colorized.

I've tried the following, without success.

Formula is =$F:$F="*spare*"

Thanks for any help you can provide !

jay

Highlight column F, then in conditional formatting, Formula Is:

=FIND("spare",F1)>0

If you don't care about the case use SEARCH which will also format cells containing "Spare" or "SPARE", i.e. just

=SEARCH("spare",F1)

Hi there,

Thanks to both of you for your responses, each of which works great. I was trying to my it too complicated.

jay