πŸ“‘ Conditional formatting, highlight row if cell contains substring

Bookmarked Conditional formatting, highlight row if cell contains substring – Google Docs Editors Community (support.google.com)

I know that to highlight a row based on a specific value, I would put the custom formula in conditional formatting as =$C2=”Apples”

However, I want the rule to apply to any row in which the C column contains the word Marketing (for example to highlight all cells that say Green Apples or Red Apples.

Also, is there a way to utilize the OR function in conditional format the entire row if C column contains Green Apples or Bananas?

Using a combination of OR and SEARCH to format a row based on a particular word within a cell:

I’ll start with your second one since it is easier:

=OR($C2=”Green Apples”, $C2=”Bananas”)

That will highlight the entire row if either condition is true.

 

For the first one, try this:

=SEARCH(“Green Apples”,$C2)

 

Or you can combine it with the OR method above to get this:

=OR(SEARCH(“Green Apples”,$C2),SEARCH(“Red Apples”,$C2))

Leave a Reply

Your email address will not be published. Required fields are marked *