How to negate MATCH or SEARCH in google sheets conditional formatting?-CodePudding

Home > Mobile > How to negate MATCH or SEARCH in google sheets conditional formatting?

How to negate MATCH or SEARCH in google sheets conditional formatting?

Time：01-15

This works:

=MATCH($F1, "searchterm")

and this works:

=SEARCH($F1, "searchterm")

These don't:

=NOT(MATCH($F1, "searchterm"))

=NOT(SEARCH($F1, "searchterm"))

Because