regexgoogle-sheetsgoogle-sheets-formulags-conditional-formattingtextjoin
Conditional Formatting in merged cell
guys, I'm trying to do some crazy things in Google Sheets and I'm getting in trouble. Can someone help me? I have this sheet with tasks and subtasks. Each subtask has a status (done, in progress or not stated)What I want to do is set one progress for task depending on its subtasks. This way:
- if all subtasks have a status not stated, the task is not stated(red color)
- if all subtasks have a status done, the task is done(green color)
- if all subtasks have a status in progress, the task is in progress (orange color)
- if we have at least one subtasks not stated, the task is not stated. Same for another status
Solution
try separately for A column with those merged cells:
=REGEXMATCH(TEXTJOIN(" ", 1, C:C), "Not Started")*(B:B<>"")
=REGEXMATCH(TEXTJOIN(" ", 1, C:C), "In Progress")*(B:B<>"")
=REGEXMATCH(TEXTJOIN(" ", 1, C:C), "Done")*(B:B<>"")
- How to combine all the words of a sentence extracted with a regex?
- 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?
- std::regex escape special characters for use in regex
- Does lookbehind work in sed?
- Regex for complex delimited string with multiple parse patterns
- Parsing PDF tables into csv with php
- RegEx for "does not begin with"
- PHP regex starting and ending with < and > produces an unknown modifier warning
- Sanitize number by removing first digit then any consecutive zeros
- How to match one or more characters nominated in a regex character class?
- Sanitize a number which may include dollar symbols, hyphens and dots
- Validate a numeric filename which may only be between 01 and 12, then the file extension
- Regex for number check below a value (12)
- Validate a string containing a number, underscore, then an number with a maximum of 12 digits
- Regular expression that allows only a specific special character when it has a specific length
- java - regex pattern matching days, hours, minutes, seconds
- Regex pattern for matching words between two delimiters
- Matching a String in Python using regex
- How to match and extract string matching regular expression
- Problem subsetting a string from a filename
- Remove all non-alphanumeric characters but keep float values