J
james
Hi,
I run some forecasting sheets for my work using excel, and have come
across a problem.
Basically there are multiple columns with each customer, and multiple
rows with week 1 to week 52. The people in charge of forecasting must
finalise their predictions 5 weeks in advance. I have written a
conditional formula that makes the cell grey if that cells date is
less than 5 weeks away. However I would really prefer to have this
cell locked, and passworded.
Is there any way of doing this?
Additional information:
The first cell this applies to is T11. (down to T62) Then rows Z, AF,
AL etc all way until ED.
Thanks in advance,
James
I run some forecasting sheets for my work using excel, and have come
across a problem.
Basically there are multiple columns with each customer, and multiple
rows with week 1 to week 52. The people in charge of forecasting must
finalise their predictions 5 weeks in advance. I have written a
conditional formula that makes the cell grey if that cells date is
less than 5 weeks away. However I would really prefer to have this
cell locked, and passworded.
Is there any way of doing this?
Additional information:
The first cell this applies to is T11. (down to T62) Then rows Z, AF,
AL etc all way until ED.
Thanks in advance,
James