trying to create a form that will stop you if you leave a cell bla

  • Thread starter Thread starter CarTel Boy
  • Start date Start date
C

CarTel Boy

If you leave a cell blank with a particular row, I want to not let the person
move forward by either locking or hiding the following cell. For example if
A1 is blank then B1 is no accessable, if B1 is left blank then C1 is not
accessible.
 
You can do it with custom data validation.
Data -> Validation... -> Custom -> =A1<>""
Ensure that you uncheck Ignore Blanks
 
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

Excel Add ^ to a row of cells containing letters 3
Stop users leaving cells blank 8
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Create if partial match then copy and paste data from one cell to another 1
How do I have the result of a formula display in a blank cell 3
CAN YOU SOLVE THIS!!!!!!! 2
Can you do it ??????? 2
length of line depending on the value of the cell 13

Back
Top