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    Apr-14, 2015
question by Speech maven:!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?