I know how conditional formatting works, but I don't know how to implement a specific formula. For example, I want the cell to be highlighted if any of the animals below is mentioned. I was thinking of creating a conditional formatting rule for each of them, but I think that's not efficient.  There has to be a simpler formula.AardvarkAbyssinianAdelie PenguinAffenpinscherAfghan HoundAfrican Bush ElephantAfrican CivetAfrican Clawed FrogAfrican Forest ElephantAfrican Palm CivetAfrican PenguinAfrican Tree ToadAfrican Wild DogAinu DogAiredale TerrierAkbashAkitaAlaskan MalamuteAlbatrossAldabra Giant TortoiseAlligatorAlpine DachsbrackeAmerican BulldogAmerican Cocker SpanielEDIT: Here's an example. My goal is to get Column E's cells to get highlighted if any of the words match any item in  Column A
In Google Spreadsheets, what formula should I use for the Conditional Formatting option if I want it highlighted if a word matches my list?
google spreadsheets