regexgoogle-sheetsgoogle-sheets-formulags-conditional-formatting
Google sheet conditional formatting if the cell contains ref to another sheet
Is it possible to create conditional formatting that will color a cell if it contains a reference to a different sheet of the same document? More generically, is it possible to create a conditional formatting based not on the value of a cell bu on the formula behind a cell?
I hope my question is clear!
Solution
not very clear but if you are after this then it's possible:
custom formula would be:
=ISFORMULA(B1)
this would highlight all formulae of course so you will need to further narrow it down for example by using FORMULATEXT with regex like:
=ISFORMULA(B1)*REGEXMATCH(FORMULATEXT(B1), "^\=[A-Z]\d|^\={[A-Z]\d")
which would not highlight any other formulae like for example =SUM(1+2)
- 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?