I'm trying to find blank cells and issue a warning message.
I have tried the following.
(1) Conditional Formating
Worked, but this only highlights the cell in red no warning.
(2) Cell formula IF(ISBLANK(CELL), "error",)
gives me a circular reference error.
Does anyone know a way to do this?
It seems like an easy task, but it has escaped me.