Conditional formating if text contains

Sorry, this sounds like a basic thing, but I haven’t found how to do it or a post. I just want to get certain format in a table if the text contains some text. Let’s say I would like to have green color if the text has “apple” on the row.

Thanks in advance.


Is something like this what you are looking for?

I achieved this using Conditional Formatting - full article here: You can also play with the example, but here is a guiding screenshot:


1 Like

Thank you. Yes, but what if the text says “Delicious apple”, I would like to still have the color set to green. Is that possible?

With that same setup Joseph_B posted, try this equation for the conditional formatting:


Fruits is the column you’re checking.
Lower() makes everything lowercase to make sure you find every match.
RegexMatch() is the Regular Expression Matching that finds the text even in a sentence.


That worked! Regermatch() has the function I was looking for.

Thanks a lot.

1 Like