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     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.

ABCD
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.
-------------------------------------------------------------------------------------------------------------------------------