How to dynamically protect google sheet cells ranges when certain conditions are met

preview_player
Показать описание
Any questions please ask in the comments.
Рекомендации по теме
Комментарии
Автор

Been looking for a way to do this for a while. Many thanks.

yuri
Автор

I used your steps but when I don't enter a value in B2, the warning message appears( and that's ok). I don't know after clicking ok in the warning message jumps to cell continues going to B4, B5. etc. I wish there is a way that after the warning message stays in that cell(B2 for example) Any suggestions?

OSCARPION