All,

Is it possible to make a formula permanent in a cell. Even when the cell is filled it and then the data again removed?

Example.
The below formula is written in C12 looking in C11.
=IF(C11="YES" ; "Please Fill in C12" ; " ")
And now, The cell C12 will be filled in with than normally you will 'overwrite' the formula in C12.
Is there a way, that if I delete the 'value' that is filled in, I get the "formula" back in. (without having to copy paste the formula).
Reason why? this sheet will be used by others who aren't really advanced in excel.
(without macros if possible).

-=CWever=-