Formula to check if cell "contains" specific text

Ask for Help Formulas
#1

Hi
I want to change the cell style (background color) if the cell contains specific text, as opposed to == specific text.
That is, I want certain words to be flagged but they should also be able to have additional text.

#2

You can use this formular:

"Baa" in $A

this returns True when the text “Baa” is in $A.
But this only works if the text is exactly in $A (case sensitive).

For a case insensitive match you could use:

"foo".casefold() in $A.casefold()

This also works if $A contains a text like “Foo” or “FOO”.

Here is an example document:
https://docs.getgrist.com/g5MTkuro8pP1/Text-Match

1 Like
#3

Thanks so much… I didn’t get a notification for your response. AWESOME!