@ > Home > Contents > Conditional cell protection Excel 4+

Task and Solution (Klaus Perry Pago)

B1: shall be changed only if A1: values to "ok"

B1: Data Validity UserDefined Formula =$A$1="ok" 
Uncheck [ ] Ignore Empty Cells

This preserves only from overwriting, not from being copied to.