yogi_Conditionally Format Rows If Cells A11:D32 House An Entry Delineated In A Specified List E2:E

Google Spreadsheet   Post  #2042

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-21-2016

post by: hoolamonster:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/beCuzLLHj1s;context-place=mydiscussions
Highlight a row if a cell contains certain text.

in response to the comment by holymak...

In response to your query about an example.
Rather than a separate formula for each word ,I was after a single formula with multiple words:

E.g. Rather than =("rain"........)  would it be possible for

=("rain","United","wet"......)

Your formula works well but I have to write a conditional format for each word( which means hundreds of formulas).I want to be able to conditional formal rows that contain either of a number of words to be coloured a specific colour.
So if a row contains either " rain" and or "wet" and or "united" etc then that row would be a specific colour.

Any idea?

---------------------------------------------------------------------------------------------------------------------