try
=or(not(iserror(find("wires",a2))),not(iserror(fin d("power",A2))), etc)
in your conditional fomat formula. If the case may be sensitive, you may
have to play with it somewhat.

"GerryK" wrote:

Could I please get some advice on how to make this formula (or some other
one) to look for more words?

=SEARCH("wires",A2:$AB$2000)

I'd like to conditionally format cells in AB that contain the words wires,
power, lines, cable.

TIA