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