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