As long as the cell is going to have a formula, the cell will never be empty.

If I have to make sure that the blank looking cells are really empty, I'll use
this technique.

I'll use a formula like:
=if(a110,"too big",na())
And drag down the range

Then I'll clean up the #n/a's. But this will lose the formulas from those
cells.

I'll select the range
Edit|goto (or F5 or ctrl-g)
Special|formulas|Check errors (uncheck the other choices)
hit ok
hit the delete key on the keyboard

Remember that this deletes the formulas in those cells!

Eric wrote:

If condition does not meet, then nothing in cell, which I use "" to define
blank cell, however, some plug-in for Excel cannot recognize "" as a blank
cell.
Does anyone have any suggestions on another approach to define blank within
formula?
Thanks in advance for any suggestions
Eric

--

Dave Peterson