ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   trying to create a form that will stop you if you leave a cell bla (https://www.excelbanter.com/excel-programming/420204-trying-create-form-will-stop-you-if-you-leave-cell-bla.html)

CarTel Boy[_2_]

trying to create a form that will stop you if you leave a cell bla
 
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.

Jim Thomlinson

trying to create a form that will stop you if you leave a cell bla
 
You can do it with custom data validation.
Data - Validation... - Custom - =A1<""
Ensure that you uncheck Ignore Blanks
--
HTH...

Jim Thomlinson


"CarTel Boy" wrote:

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.



All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com