Google Sheets Format a Row depending on the contents of a cell in the row
I need help with conditional formating. Essentially the problem is as follows:
If cell 'D3' has text in it that starts with the letters 'BLDUK-ORD' then I need the entire row to turn orange.
Then if cell 'E3' has any text/numbers in it then the entire row needs to turn green.
This will need to be implemented down my entire google sheets document (over 30,000 rows of data currently). Thank you.
Exemplar sheets document: https://docs.google.com/spreadsheets/d/1inkIGMD11AeZ0uTdm60M2G2efu_lPv4Ak3IqGbcyCvU/edit?usp=sharing
Solution
try on range A3:Z...
green:
=($E2<>"")*(REGEXMATCH($D2&"", "^BLDUK-ORD"))
orange:
=REGEXMATCH($D3&"", "^BLDUK-ORD")
- How can I make these html & php patterns work?
- Replace backslash '\' with forward '/' slash in VS Code snippets with Regex
- Python regular expression for multiple split criteria
- Using regular expression to extract substring
- Regex to find a float
- Regex replace with a small text change?
- Regex for one or more words separated by spaces
- How does Python's unittest library match patterns passed via the -p parameter?
- What regex can allow a delimiter, but only if the surrounding groups exist?
- Apache Nifi Expression Language: find part of content, which matches to regex
- Using a gsub to split a name based on special characters
- Extracting only characters from a string in Python
- RegEx for word boundary but still match if is preceded or followed by special chars
- Analogue for regex '?' (preceding item optional) in T-SQL like?
- Private IP Address Identifier in Regular Expression
- Whitespace woes in Regex
- Visual Basic .net Regex match does not work - despite working on a testing tool?
- Extracting with regex two conditions of some text
- Google Sheets Regex for the inconsistent pattern
- String Expansion program gives incorrect output
- regex to remove ordinals
- Using gsub to extract all information before and after the first white space
- How to replace all BUT the first occurrence of a pattern in string
- How to solve JS Regex not working during keypress
- Match whitespace but not newlines
- Regex - Match repeated character not in sequence
- Regular expressions: Matching strings with dot (.)?
- How to deal with Polish Characters while using regex?
- ADF - Dataflow expression builder cleaning/parsing columns
- Can I test if a regex is valid in C# without throwing exception