regexgoogle-sheetsgoogle-sheets-formulags-conditional-formatting
GS Conditional Formatting multiple range matching multiple values
On my Google Sheets document, I have two ranges with a dropdown list, and basically, I want to color cells according to the value selected of the dropdown list, but by a group of values.
Imagine the values possible are: toto, titi, tutu, foo, bar.
I would have one rule that apply a format on cells of columns A and C (A2:A11,C2:C11) that match toto or foo.
Solution
you can use regex like this:
=REGEXMATCH(A2, "toto|foo")
- Regex for matching a certain number of words
- How to convert "camelCase" to "Camel Case"?
- Negative Lookahead not working in perl regex
- How can I get Vim to highlight non-ASCII characters?
- Regex: Match specific characters in any order without more occurrences of each character than specified
- How to parse names and percents
- PowerShell multiline regex is matching on regex101.com AND regexr.com, but not in Powershell code
- How to get second material name from product description
- How to find second match in sql
- Substitute a regex pattern using awk
- Custom String statement to mathematical operation [PYTHON]
- Regex to match up to 9 num. chars followed by 'ml' and those 9 num. chars don't fall between 1900-2199, but not a Quote char followed by 2 num. digit
- Python re.sub: ignore backreferences in the replacement string
- python re.sub group: number after \number
- Validating email addresses using regular expression with Razor syntax
- How to replace host part of a URL using javascript regex
- Escaping $ variable interpolation in a multiline match
- Match characters between square brackets but only if text inside brackets follows pattern
- How to combine all the words of a sentence extracted with a regex?
- Using regex in python to parse a string for variables names and values
- How can I detect all symbols on mathematical operators on PHP using regex?
- RegEx for combining "match everything" and "negative lookahead"
- How to validate an Instagram username
- Parse video id and start time from differently formatted youtube URL strings
- Python - regex to grab specific lines from text
- how to escape texts for formatting in python
- Regex not correctly rejecting invalid music note values
- regex - error with result - too many occurence
- Parse a formatted, single-line string into an array of associative arrays with predefined column names
- How to split a string by any of multiple delimiters?