Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 08/08/2018 - 02:49
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc