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

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.
 
J

Jim Thomlinson

You can do it with custom data validation.
Data -> Validation... -> Custom -> =A1<>""
Ensure that you uncheck Ignore Blanks
 
Top