I am using the formula below with conditional formatting to turn a cell green in column B if it contains the value from column F2 through F4
=ArrayFormula(REGEXMATCH(B2,join("|",$F$2:$F$4)))
I would like it to turn cells in column B green if it contains a value from F2 but my current formula is only returning exact matches. How would I modify the formula?
thanks so much.
=ArrayFormula(REGEXMATCH(B2,join("|",$F$2:$F$4)))
I would like it to turn cells in column B green if it contains a value from F2 but my current formula is only returning exact matches. How would I modify the formula?
thanks so much.