Lock and Grey Out Cells Based on Cell Value | Based on IF Condition | Based on Drop-Down List

[@keningilbert]

Wow you knocked out of the park by providing so many examples! Thank you!

[@IvanCortinas_ES]

Excellent, deep and clear exposition of the matter. Thank you Chester!!!

[@oladman9058]

Just what I needed. Many thanks

[@williamsharpe2393]

What if the column is a list using data validation already?

[@teoxengineer]

Good topik 👍

[@abdulhamidalhaddadi2255]

THANK YOU SIR

[@MohdSaifoulAzuan]

Thank for the video .

[@FRANKWHITE1996]

Great video. Thanks for sharing.

[@redhaakhund1271]

Thank you so much. As always you are 👍👍👍👍👍

[@mauretto1987]

What is the formula to choose from multiple values in a drop-down list between quotation marks?

[@mohamedel-sharkawy5537]

Excellent 👍

[@bjrn-eirikroald5411]

My issue with this method is while data validation can be used to protect cells from being edited, it does not stop you from deleting the contents of a cell. So using this method to protect cells from being edited accidentally is not an option. I realized that you can lock cells be protecting the sheet and changing the protection of the cell to "locked". However, this is very cumbersome to do often.

[@TerraMaeStudio]

Wondering if it is possible to do this in Google sheets? In particular example 3?

[@matthewzantua2336]

wow nice!

[@jirehgracevillamejor6601]

Can this be done if I have an existing VBN codes for another formatting?

[@grisheldamarks-webster-noa1706]

How do you hide cells on one sheet (B) based on cell value on another sheet (A) with macros or on a sheet that is protected? It works until I protect the sheet (B) with the hidden rows. Thanks

[@tosh369]

Is there a way to "Protect" a cell or cells based on the value in another cell? In other words, the cursor should just tab over the cell/

[@pitekfatale2]

I did data validation for open and closed but I can only choose "open. closed" and not "open" and "closed". What I did wrong?

[@ken00000]

How to do this in Google Sheets?