Verify if a string entered in a cell appears in one of the cells in the column next to it, case sensitive
In my Google Sheet, I have a list of company names in column A. I need to enter a list of company names in column B, and highlight any cells in column B if the name in that cell does not appear in column A. This needs to be case sensitive.
For example: if Burger King is in column A, and BURGER KING is entered in Column B, that cell in column B should turn yellow. If Burger King is entered in column A, and Burger King is entered in column B, that cell in column B should remain white. If McDonald's is entered in column B, but does not appear in any cell in column A, that cell in column B should also turn yellow.
I tried using conditional formatting on column B with a custom formula of =countif(ArrayFormula(find(A:A, B2)),1)=0 and it appeared to be working at one point but is not currently working.
try:
=NOT(REGEXMATCH(B1, TEXTJOIN("|", 1, A:A)))*(B1<>"")
- How to validate an Instagram username
- std::regex escape special characters for use in regex
- Regex not correctly rejecting invalid music note values
- 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
- Get float value without its unit of measure from a string
- Get float number in string which is nor preceded by $ and not followed by %
- Extract ip and uag from Cloudflare cdn-cgi/trace text result using regex in JS
- Count number of matches of a regex in Javascript
- Want to write regex in javascript which will check if all the mentioned chars exist at least ones
- How to validate file name and file extension from single Regex?
- Regular expression for GB based and only numeric phone number
- Regex should not match for two or more consecutive dashes
- Concrete JavaScript regular expression for accented characters (diacritics)