EVDRE Formatting: CRITERIA is INPUT and USE is LOCK
Goal : lock calculated cells for input on a BPC EVDRE input schedule which is dynamic in rows and cols
What should my format range look like and what is my protection setting?
Marcel Frey replied
You format range should look like the following
CRITERIA EVALUATE IN FORMAT USE PARAMETERS APPLY TO
CALC 123 LOCK DATA
You should lock the cell with the "123" (Format Cells / Protection / set tick in "Locked")
After that, go to the "Workbook Options" and set a password.