regexgoogle-sheetsgoogle-sheets-formulags-conditional-formattingtextjoin
CheckBox to Highlight Range Google Sheets Formula/ Google Sheets
I am trying to get the result in the image attached. If I check a checkBox in Column A, I want it to also to highlight the same SKU & Location Column H,I(in Bright Green). Conditional formatting or if script could do this?
Solution
try:
=REGEXMATCH($H2&$I2, TEXTJOIN("|", 1, FILTER($B$2:$B&$C$2:$C, $A$2:$A=TRUE)))
UPDATE:
=REGEXMATCH($H2, TEXTJOIN("|", 1, FILTER($B$2:$B, $A$2:$A=TRUE)))
- 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