yogi_Conditionally Format Rows If Columns A And Or B Contain The Word 'Rain'

Google Spreadsheet   Post  #2039

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

post by: holymak:

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

	A	B	C	D
1	The rain in Spain	Fifty Shades	2	3
2	Manchester united are struggling	Thats Life	5	6

So,for example I would like the whole of the row(A1:D1) to be high lighted if the text in column A or B contains "rain".

Is this possible ?

Grateful for any help.

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