Google Sheets - Conditionally Lock Cells Based on Other Values

Hello thanks - it worked great but what is I need two values Shipped and Delivered for example. I tried to use formula with OR but does not work. Please can you help me?

Hi sir I really like your videos and are very helpful. Sir If i selected the entire sheet and i want to lock the specific cell after entering the data is it possible if Yes then how.

Thank you for this. I already have data validation on the cell, to enable it to show a drop down list, but I'd like it only to be active if another cell has no data in it. It looks like I can't apply a second data validation rule to the cell. Does anybody know if this is possible?

Amazing.! 😁

Thank you, great video. Is there a way to do this with a checkbox in the conditional cell? Like if the checkbox is checked (=true) then the other cell is locked? I'm having trouble with this. Thank you for any thoughts.

and of courseawesome tutorialsl nice intro music. ;) thanks

Thank you Sir 🙂

Thanks.. thats what i looking for some times.. thank you so much..

What if the cell you would like to lock is a tickbox. Rule needs to be "If tickbox A10=FALSE then you wont be able to check the tickbox in A11". Sounds simple enough. But whenever I try this solution the cell just automatically becomes a text-cell.

is that possible using check boxes? im trying to do that but it changes the check boxes with true or false values when i add a data validation

Hi, Can I have similar validation based on system date>=today(), Reject data entry, I tried with formula at refering to cell with a text output as "Lock" =if(today()>=(2022,31,10),"Lock","") it could work, but gives a warning message at cell range, However I want to hide the (Top right red trangle "Error" validation mesage warning"), as I do not want user to know that the cell range has a validation in it, can I have multiple validation refereing t same range!! awaiting on your solution, thanks in advance

Hello,
Do you know if the users can modify the data validations, also the formating (conditional or not) etc... .
Can we prevent this (or is it already) ?
All what I know about this is :
Protect cell => Unauthorized user cannot do anything on the cell.
Unprotect cell => Everyone can do everything with the cells ... (format, validation etc ...) (afaik)

Thanks a lot sir,

I tried this but they delete data from the protected cell or did i miss something?

what if i want to validate cells for "Pending" and "Out of Stock" together?

How to lock a cell based on multiple values in a particular cell? Can you please help me with this.
Like if status is pending and shipped both should be allowed

Thank you so much for the content!

If conditionally locked cells are built as formulas that rely on other sheets for the data presented, will those formulas continue to automatically work or will a conditional selection like "Closed" prevent the data from updating?

/Seems like this does not work if the cell you are supposed to lock is a drop down list :( is there any alternative?

Hello! Thank for this! Helpful info. Is there a way to also make it so that a user cannot delete the info that is already in the cell at that point? It works for rejecting input, but i want to use it to reject new input AND reject deleting of the content of the cell.

Thanks for your efforts however, this is not working if users copy data from another file and paste it here.

Sir,.. Please use apps script same function. (conditionally lock cell/row/ column based on other cell)..Thank you.

Thank you. Exactly what I needed, and well explained and demonstrated.

HOW TO CONDITIONALLY FORMAT A COLUMN VALUE BASED ON ANOTHER CELL VALUE THAT CHANGES IN REAL TIME

LET SAY,
FROM V3TO V17 I HAVE PE RATIO OF SOME COMPANIES. I AVERAGE THAT VALUE IN ANOTHER CELL (H7). NOW I WANT TO PUT A CONDITION IN V3 TO V17, WHICH CHANGES THE VALUE BASED ON VALUE ON H7

How to do if I want to lock based on the day date like enter data on the same day only

Thank you for this. I just tried it and I am wondering if there's a way to not show the error on data that was previously entered.
I'm placing an order as a group but I want to reject changes once the order is set to "closed" without it showing the warning for the preexisting values. Thank you!

Did you know that people like you, are great. Thank you very much.

IF I DRAG OR DELETE IT STILL WORKS.. ONLY IF YOU INPUT WILL SHOW WARNING

How to lock cell if cell is blank using appscrit

So you have a script for this? Doing the validation data is useless when user will paste a value to it as it will overwritten that particular cell.

how do you skip certain cells that can not be entered and to cells that can be entered through tabbing. like doing data entry job.

Hi There. Thank u for the great content. Is there a way to only allow cells to be edited on specifc dates? If i have a sheet where staff manually input their working hours that has the dates in column 1. Is there a way to stop anyone editing previous dates input values? Thank u

Thank you for this. What is the formula if we have multiple values that satisfy the data validation?
For example if we want to add tracking numbers for both Shipped and Pending?

Good morning sir, I just want to restrict color range in google sheet, so that no one will be able to change colour of sheet, only owner can change color of sheet. Is it possible? If yes kindly guide me.

Thanks for your video, I want to apply the rules for every individual row in conditional with checkbox. Please help me to do make it.

Like :-
Colum A2 will be able to edit when Colum B2 is uncheck
Colum A3 will be unable to edit when Colum B3 is check
Colum A4 will be able to edit when Colum B4 is uncheck
Colum A5 will be unable to edit when Colum B5 is check

Hello sir, is there a way I can make a Shared sheet on Google ( which will be a attendance sheet) where , Columns will be > Date | User 1 | User 2 :- 1) One user can not make entry in other user's column 2) no one can make entry/ edit in Past date 3) Hide Data Validation Option Under 'Data' Menu Option.

the trick that you used for drop down list open & close worked fine as I wasn't able to add new entries but it had one problem that is I was able to delete old entries using Backspace or Delete button

what if shipping status is blank and we try to access the column were data validation is applied

Thank you!
Can I copy this and apply at once onto another Sheets with the same formats and design!

I have multiple drop downs made from data validation "list from a range". How can I retain this and also prevent people from engaging the other drop downs until the first on is selected?

I want to lock cells in a row after entering the data in the cells in that row by selecting a yes or no from a drop down list at the end of that row. "is the data in this row complete?" yes = locked row. Can someone please help.

not working if I using google finance :(

Thanks, I was looking for this example. It was a great help for me

thank you.

Thank you for the Tutorial. This is really helpful.
What about if the Cell range already has a Data validation. Like a Dropdown menu or Check box.
Is there any solution for this.

Hello! I hope you are keeping well

This is exactly what I was looking for

but

I do not have access to google sheets at my office. I have been trying to mimic your approach in Excel. Not able to get the result

Please , suggest an alternative or may be an excel version of this.

Thank you

Not exactly in Google sheet but in Excel, can we achieve following

Can we have method to automatically "unlock" (for any operation) a otherwise "locked cell" in protected sheet depending on value of another cell ?

Let's say I have a worksheet in which all the cells are protected in column O.

My column D has drop down menu to select from @ 58 list.

What I want to achieve is if someone select from drop-down "subtotal" in any row in column D, respective cell in that row in column O shall be unlocked for subtotal.

How we can achieve this.

Looking forward and thanks in advance.

This was helpful.. do u have tutorial on one drive as well?

Is it possible to use conditional formatting to lock a cell after data input? For example, all cells will be blank and once a person adds text, it locks so others cannot edit it.