Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like this:






And I want the entire column, including Potato and Octopus, to be highlighted. If the column did not have Horse, I would want none of them highlighted. I know I can do this with a massive list of AND and ORs, but there has to be a better way!

Edit: Research efforts: Googling any combination of these words gives me things I don't want. It tells me how to apply a conditional format to an entire column - but what it means by that is that it will highlight cells in the column that match X, not that it will conditionally highlight the entire column based on values inside that column. I've found a few things that work, but they're either really complicated (a series of AND/OR) or not really clear on why they work.

  • Welcome. Please add a brief description of you search / research efforts as is suggested on How to Ask. – Rubén Aug 9 at 0:05
  • if the animals are always in the same order, you can do a single check with concatenate or textjoin and regexmatch. – pjmg Aug 9 at 10:45
  • @Andrew can you provide a sample ? Or an idea of how many conditions/animals needs to be tested ? – pjmg Aug 10 at 7:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.