Field required

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate cell with multiple non-blank text values 3
Excel How to get the number of days an item was opened from the today's date. 14
Live Cycle Designer - Java Script Assistance Required 2
Testing for required data entry in form fields. 6
Mandatory Cell completion for multiple worksheets in a workbook 0
Prevent printing if required field is blank 2
Word Lock specific drop downs on a Word Document 0
Pivot Table selection that will allow Grouped fields to show up ineach cell 1

Back
Top