Search for more than one word
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
|