I am trying to lock only column B which has a formula in it.
The reason I am trying to lock it so when someone else inputs data into the sheet they don’t mess up the formula; the formula is in each cell of column B up to row 1200.
I also would like to be able to have full edit permission so i am able to highlight all cells in the row once that data has been entered into a respective program.
This sheet is just to track if data has been entered into another program.