Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google sheets isformula() equivalent?

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?

like image 506
jason Avatar asked Apr 23 '14 07:04

jason


2 Answers

the isFormula is the standard function in new Google Sheets. You don't have to implement yours one.

=isFormula(F2:G5)
like image 183
user2886836 Avatar answered Nov 01 '22 12:11

user2886836


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.

like image 34
Juan Pérez Avatar answered Nov 01 '22 12:11

Juan Pérez