View original (French)

How to Lock a Cell Based on Another in Google Sheets

resp -  
JCB40 Posted messages 3067 Registration date   Status Member Last intervention   -
Hello, in Google Sheets (not in Excel):

I am looking for a solution to lock (neither modify / nor delete) a cell based on the value of another.

Thank you for your help..
Best regards.

1 answer

  1.
    JCB40 Posted messages 3067 Registration date   Status Member Last intervention   479
     
    Hello,
    A sample of your file with explanations would be welcome.
    To send a file,
    Make sure there is NO CONFIDENTIAL DATA
    you should use an attachment site like cjoint.com

    Go to this site: https://www.cjoint.com/
    Click on browse,
    Find your file,
    click on open,
    Click on "Create the cjoint link",
    Copy the link,
    Come back here to paste it in a reply...
    Best regards
    0
    1. respcond Posted messages 3 Status Member
       
      Hello, and thank you for your help.

      Since this is a Google Sheets file, here is a link with editing access.

      https://docs.google.com/spreadsheets/d/1dPun_8OXvj9Ga_sk_IQPWrPG5oC1xa6XDSx9Ye50gtY/edit?usp=sharing

      Currently, I managed with a "data validation" trick to make it so that the cells in a row can no longer be edited when the one at the end of the row is checked. However, what I don't like is that you can still easily erase the contents of the row..

      Thank you in advance.
      P.S.: This is a file I want to create for an association.

      Best regards
      0
      1. JCB40 Posted messages 3067 Registration date   Status Member Last intervention   479 > respcond Posted messages 3 Status Member
         
        Hello
        A bit more explanation would be nice
        1° protected file I can't do anything
        2° where are the checked cells
        3° protected file I can't delete anything?
        Best regards
        0