Hihi
I have some columns (Q - U) that is running on formula linked to column P. Depending on the value generated in column P, the responses under columns Q - U differs. When Q - U yield "N.A.", i would like excel to lock the cells.
Eg. if P5 is showing "Sale", the the corresponding S5 and T5 should be unlocked, but Q5, R5, and U5 will be locked.
Any help is appreciated, thanks so much!
I have some columns (Q - U) that is running on formula linked to column P. Depending on the value generated in column P, the responses under columns Q - U differs. When Q - U yield "N.A.", i would like excel to lock the cells.
Eg. if P5 is showing "Sale", the the corresponding S5 and T5 should be unlocked, but Q5, R5, and U5 will be locked.
Any help is appreciated, thanks so much!