P
P
parvus2018-11-12 01:13:04
Google Sheets
parvus, 2018-11-12 01:13:04

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

1 answer(s)
A
Alexander Rocket, 2018-11-12
@SashaRocket

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 question

Ask a Question

731 491 924 answers to any question