Friday, April 17, 2015

yogi_Conditionally Format Cells Of A Column Based On Cells Of Column Housing Specified Set Of Phrases


                                           Google Spreadsheet   Post  #1945
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr-14, 2015
question by Speech maven:
https://productforums.google.com/forum/utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/_GzEorA7OMM
Multiple exact matches in conditional formatting
I'm trying to use conditional formatting to give a distinct background color to groups of words.  E.g. the words: Horse, Cow, Hog will have a blue background and the words Tower, House, Tent a red background.  Is there a way to enter these as two rules rather than 6? 
----------------------------------------------------------------------------------------------