Conditional formating if text contains

1

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.

2

Hello,

Is something like this what you are looking for?

I achieved this using Conditional Formatting - full article here: https://help.coda.io/en/articles/776289-table-conditional-formatting. You can also play with the example, but here is a guiding screenshot:

image

1 Like
3

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?

4

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

Fruits.Lower().RegexMatch("apple")

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.

3 Likes
5

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

Thanks a lot.

2 Likes