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.
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:
Thanks so much… I didn’t get a notification for your response. AWESOME!