For example i have this in A1 :
If in A10 i accidentally enter a value (which will overlap with arrayformula result) , it will produce error in the A1 because of existing value. But is there anyway if i want to flag this cell A10 with conditional formatting?
For example if i enter " " (space) , all the cells will be blank without me knowing which one is has problem, except if i check error notification. So in big sheet matrix it's faster for me to spot by coloring the cell.
How can i tell if the A10 has a non-formula value or the result of arrayformula() in A1 ?
isformula() only works if there's a formula in A10 not as as the result of arrayformula().