Field required

[t848]

Is there a way to require something in a blank field on a protected document?
I have a protected excell doc. and I want some way to require some type on
entrey into each unlocked field. Some fields on the form are being left blank
and I want some type on reminder to prompt users that there are still blank
fields on the form
Thanks
tboyle

 

[Dave Peterson]

I use an adjacent cell (or column of cells) with formulas like:

=if(a1<>"","","Please enter something in A1!")

And give that cell a nice bold red font.