When I use QUERY() and rows of results are returned, I would like to have conditional formatting so that I can see which cells I shouldn't edit because they are produced by a formula. I currently use ISFORMULA(A1) to identify cells that have a formula in them. I would also like to format the cells filled with the results of my QUERY().
1 Answers
results of QUERY as an endpoint are undifferentiable from standard manual input so the only thing you can do is to run QUERY within conditional formatting like for example:
=INDEX(REGEXMATCH(A1; TEXTJOIN("|"; 1; QUERY($A:$B; "select B where A is not null"; ))))
Related