With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, February 21, 2016
yogi_Conditionally Format Rows If Cells A11:D32 House An Entry Delineated In A Specified List E2:E
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
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.