Protect cells based on values in another cell

[Madhaan]

Hi Helper,

I have one query, I have coding to the range of cell which double clicks it turns to "Green", Now my query is with the range if there is "Green" other cell should not allow me to enter anything. Can any one help me on this.

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Madhaan]

HI Pepe Le Mokko,

Thanks for the reply, i am not able to attach the file.

[AliGW]

Yes, you are able to attach the file.

1. Desensitise your data - we only need a SMALL representative sample.
2. Follow the instructions in the yellow banner at the top about attaching workbooks.