Hello, I have the following issue where I can't wrap my head around.
I have a column which has text and I have to find if there's something which has a word which shouldn't be there.
So I have decided to use Conditional Formatting and use the option Format only cells that contain: -> Specific Text -> Not Containing
I can put 1 word in the section, but I have to have 10 words for it.
Currently I haven't found any solution which works for me: tried something like =OR("RED";"YELLOW";"ORANGE";"BLUE") , but unfortunately it doesn't work.
Any ideas guys?
Bookmarks