hey!,
i'm using google spreadsheet and trying to search for words from a criteria list with conditional formating, I only run into 2 problems...
This works if I'm in the same sheet as the criteria list and the data.
1.
=ArrayFormula(REGEXMATCH(A1,join("|",K$6:K$7)))
but if I want to put the criteria list in another Sheet;
2.
=ArrayFormula(REGEXMATCH(A2,join("|",Config!E$2:E$5)))
Then google conditional formatting gives an error that the formula is incorrect :/ (If I test formula 2 in the data sheet it works, but not if I want to use it as a formula for conditional formatting.)
how can i use "isblank" in this formula? so that using Config!E:E becomes a bit easier?
Bookmarks