I want use a cell in regexmatch as regular_expression parameter. My goal is to draw green background for A1 if B1 contains A1 inside of it. How to do this with regexmatch?
-
Please add more details. By the way, did you already read the help article about regexmatch? – Rubén Jun 1 '16 at 16:11
-
1It is completely unclear what you want to achieve. – user79865 Jun 2 '16 at 0:22
-
I have added comments – Mediator Jun 2 '16 at 6:42
-
It's still unclear what you're after. Could you perhaps provide some sample data and your expected output? – ale Jun 2 '16 at 11:09
You can use conditional formatting with the option for custom function:
=IF(ISTEXT($A$1:$A),REGEXMATCH($A$1:$A,$B$1:$B),)
