Question description:
This user has given permission to use the problem statement for this
blog.
trying to creata a spreadsheet that has particular cells where a user would enter text and numerical data.
i would want the whole sheet to be locked but if someone enters data in the first cell it would unlock the next cell for the person to move on to. this same code would run for the whole sheet.
Solved by S. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/08/2018 - 02:09
Hi! welcome to got it pro, how may I help you?
User
08/08/2018 - 02:09
hi, i am creating a spreadsheet that has cells that a user would enter both numerical and text into cells
User
08/08/2018 - 02:09
i want the sheet to be locked completely
User
08/08/2018 - 02:09
and once the first cell is entered
User
08/08/2018 - 02:10
it unlocks the next cell to be filled in
User
08/08/2018 - 02:10
this will cary on for the whole sheet
Excelchat Expert
08/08/2018 - 02:11
can you pleaes give a short example of what your trying to accomplish?
Excelchat Expert
08/08/2018 - 02:15
i see..thanks for the example..let me try data validation ifrst
Excelchat Expert
08/08/2018 - 02:37
got it
Excelchat Expert
08/08/2018 - 02:38
in cells e4 to e52
Excelchat Expert
08/08/2018 - 02:39
i added data validation formula where in you cannot enter in those cells if the preceeding cell is blank
Excelchat Expert
08/08/2018 - 02:39
you can try it
Excelchat Expert
08/08/2018 - 02:39
I hope this solves your problem
Excelchat Expert
08/08/2018 - 02:40
by the way, to create a costum formula validation you go to Data>data validation>criteria>choose costum formula is
Excelchat Expert
08/08/2018 - 02:41
the validation formula here is =and(ISblank(preceeding cell)=False)
Excelchat Expert
08/08/2018 - 02:41
basically the formula checks if the preceeding cell is blank or not
Excelchat Expert
08/08/2018 - 02:41
Does this solve your problem?
User
08/08/2018 - 02:42
i think so
User
08/08/2018 - 02:42
i will have to try this out
Excelchat Expert
08/08/2018 - 02:42
great..glad to hear that..yes..please do try it
User
08/08/2018 - 02:46
just trying it now and just having troubke
User
08/08/2018 - 02:46
trouble
Excelchat Expert
08/08/2018 - 02:46
ok..what's the trouble?
User
08/08/2018 - 02:47
as i enter it into the formula box it comes up saying "a named range you specified canot be found"
Excelchat Expert
08/08/2018 - 02:48
let me show you in the screen
User
08/08/2018 - 02:49
ok
Excelchat Expert
08/08/2018 - 02:49
=and(isblank(E3)=FALSE)
Excelchat Expert
08/08/2018 - 02:49
did you copy this formula in cell e4?
User
08/08/2018 - 02:50
so i put it in the cell
Excelchat Expert
08/08/2018 - 02:50
yes thats correct..thats what i mean when i said "preceeding cell"
User
08/08/2018 - 02:54
if i want to unlock E4
User
08/08/2018 - 02:54
do i have cell E3 highlighted when entering data validation formula
Excelchat Expert
08/08/2018 - 02:57
yes..but it only unlocks if there is a value or text
User
08/08/2018 - 02:57
ok
User
08/08/2018 - 02:58
on my sheet on excel its not working :)
User
08/08/2018 - 03:01
[Uploaded an Excel file]
User
08/08/2018 - 03:02
check out so i want B5 to unlock if b4 has text
Excelchat Expert
08/08/2018 - 03:03
i see..so you just switch the formula
Excelchat Expert
08/08/2018 - 03:03
=and(isblank(b4)=false)
User
08/08/2018 - 03:06
sorry its not working for me
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.