regexgoogle-sheetsgoogle-sheets-formulags-conditional-formattingtextjoin
Change cell background color based on text in another column
What would the syntax be to conditionally format - if any cell in Column A contains a value that matches any value in Column B then display a blue background?
Looks like this would be done using Conditional Formatting under Format, where this custom formula works.
=OR(A1:A1000="Text Sample 1",A1:A1000="Text Sample 2")
Instead of listing a bunch of values in this formula, is there syntax that can represent values listed in another column (Column B)?
Solution
use this custom formula:
=REGEXMATCH(A1, TEXTJOIN("|", 1, B$1:B))
for exact finds use:
=REGEXMATCH(A1, "^"&TEXTJOIN("$|^", 1, B$1:B)&"$")
- JS Regex MatchAll with combination of Comma & Semicolon
- Symfony Routing Host Regular Expression
- Regular Expression to parse Common Name from Distinguished Name
- Add a value and sum it up using Notepad++
- Regex for Number "05XXXXXXXX"
- Replace one character but not two in a string
- how to escape hyphen in regex character group in c
- Why do some regex engines match .* twice in a single input string?
- What do 'lazy' and 'greedy' mean in the context of regular expressions?
- How to test if a RegExp contains capturing groups in its definition?
- create regex to match format of 00:00:00 for duration (not time)
- regex for expression with one separator hyphen
- Remove special character and units form Pandas column name with Python
- Replace variables in a formula with their definitions
- RegEx to differentiate chemical compound names from pattern
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- open vimeo url in colorbox using jQuery filter
- Split address and numbers
- Pyspark Regular Expression add double quotes after comma
- In the regex world what's a flavor and which flavor does Java use?
- Problems with table extraction using pdfplumber - empty fields in large tables
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Using setCustomValidity stops input from validating