Friday, February 19, 2016

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   Feb-19-2016
post by: holymak:!topic/docs/beCuzLLHj1s;context-place=forum/docs
Highlight a row if a cell contains certain text
Hoping someone can help please.

1The rain in SpainFifty Shades23
2Manchester united are strugglingThats Life56

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.