That would be the opposite I believe.


--


Regards,


Peo Sjoblom




"Ashish Mathur" wrote in message
...
Hi,

You may also try =count(cell_ref)=1

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"how to make a cell require text" <how to make a cell require
wrote in message
...
i am makeing a worksheet and i need t know how to make a cell where it
requires a text input before it will allow you to go to another cell. I
have
questions on a sheet that i want to make have answers manditory before it
will let someone go on to the next question.