Answer the question
In order to leave comments, you need to log in
How to check if a cell has a comment?
Is it possible to make conditional formatting work after adding a comment to a Google Spreadsheet cell, for example O2?
How can I check if there is a comment in a cell (this is such crap, very similar to a note).
Answer the question
In order to leave comments, you need to log in
I think it can be done using the =ECLI() function
Example:
=if(B14="";"Empty";"there is a comment")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question