I want to lock cell 1 if the text in cell 2 is "STT". So I'm explaining that if I select STT (from the dropdown list in cell 2), cell 1 should be locked and nothing can be done to it. Can someone help me? Thank you in advance.

Lock a cell based on another cell : CCM

Answer 1 / 4

jim81818

Thank you, I'll give it a try and keep you posted :)

jim81818 Posted messages 28 Status Member

It blocks the cell even if I choose something other than STT in cell B1, knowing that cell B1 is a dropdown list (either STT, BTV, GTF, ORT).

Answer 2 / 4

The_boss_68 Posted messages 959 Registration date Status Member Last intervention 182

Good evening

A test with data validation in cell A1
Formula: =AND($B1="STT",$A1<>$A1)
Tab Data/Data Validation/Options tab/Custom

Cheers

jim81818

I did it, the problem was with my dropdown list; I needed to set the condition first, and then I had to create the dropdown list.
Anyway, thank you very much for your help.

Answer 3 / 4

The_boss_68 Posted messages 959 Registration date Status Member Last intervention 182

Re-

Select cell A1
Data Data validation
in Allow you choose Custom
and in Formula you enter this: =$B$1<>"stt"
In the Error alert tab you can enter a message that will display when a user tries to enter something into the cell while there is stt in B1

Cheers

jim81818 Posted messages 28 Status Member

It doesn't work when cell B is a dropdown list.

Answer 4 / 4

The_boss_68 Posted messages 959 Registration date Status Member Last intervention 182

Hello,

Can you upload an anonymized file on Cjoint, since I tried using a dropdown list and it worked on my end.

Regards

DrPatno

Good evening.
I have followed your messages with great interest. And I can say that I had the same observation as jim81818. With the dropdown list, everything remains static.
I just found out that you need to remove the $ signs and it should work with the dropdown list.

Lock a cell based on another cell

4 answers

Linux to replace w10

I want to download a game on my pc.

Texture issues in enshrouded

Wireless printer setup

How to install an esim on a samsung smartwatch

My surface pro 4 tablet is saturated

Problem with my sound!

Trojan horse, virus

1080p wifi surveillance camera

Infection possible