regex if-statement google-sheets match conditional-formatting

Sheets, conditional formatting

I am looking to create a conditional formatting function that will highlight "C2:E2" if "E2" > 5000 & "B2" does not contain the word "treasury".

Solution

try on range C2:E:

=($E2>5000)*(NOT(REGEXMATCH(LOWER($B2), "treasury")))

How to properly escape a backslash to match a literal backslash in single-quoted and double-quoted PHP regex patterns
jQuery Regex validation query
Java regular expression to match _all_ whitespace characters
RegEx in Notepad++ to replace text in files with some exclusions
How to filter word between two patterns - Linux
Regular Expression for URL validation
A more efficient Regex or alternative?
search using regex in JPA
Replace all occurrences that match regular expression
Are wildcards in tests always faster?
PostgreSQL adding carriage return(next line) from a long field's value
Trying to assert a date format in Cypress that has white space
ReactJS - How to fix regex error for email validation?
REGEXP in SQLite - problem while editing table
Printing first instance of match in each line of file (Perl)
How can I store a regex pattern in a MySQL field and check an input against it?
Regular expression to stop at first match
php extract Emoji from a string
Find all Git commits from authors whose email is not in certain domain (ex. abc.com)
regular expression for finding decimal/float numbers?
Different and same Regex in Ruby and JS on the same input
Regular expression for only characters a-z, A-Z
How do I renumber the numbers of this superscript?
matching a line that doesn't contain specific text with regular expressions
Sheets, conditional formatting
select records where regex equals other column
How to Use/Enable (RegExp object) Regular Expression using VBA (MACRO) in word
How do I prevent a regex from matching every other match in javascript
How to parse link extensions out of a script tag in BeautifulSoup with RegEx in Python
How to test for equal-to or greater-than zero in SQL REGEX expression?