In the new Google sheets, they added custom formula for conditional formatting. I want the cell to be blue if the cell is a value and black if it is a formula ... I've looked through all of the is
type functions, there doesn't seem to be a isformula
kind of function.
Does anybody know if this is possible?
the isFormula is the standard function in new Google Sheets. You don't have to implement yours one.
=isFormula(F2:G5)
It looks like there is a hidden built-in function ISFORMULA() from google. I realized when I deleted my own function and was still working. I tried it in a new spreadsheet and still works. No cache issue.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With