View Single Post
  #1   Report Post  
GerryK
 
Posts: n/a
Default 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