Hi,
I need help in excel for locking and formatting cell based on variable values of other cells
If A1 cell is having value of “CL3” or “GP1” or “GP2“ or “GP3“ or “GP4“ or “SB1“ or “SB2“ or “SB3“ or “SF1“ or “SF2“ or “SF3“ or “SP1“ or “SP2“ or “TB1“ or “TP1“ or “TP2“ or “TP3” etc. then B1 cell should be locked and same to be filled with red colour and if value other than above then B1 cell to be unlocked for other data input.
Same is applicable to A2, A3, A4…… and B2, B3, B4….. approx.. 500 rows.
Regards,
Pradeep
I need help in excel for locking and formatting cell based on variable values of other cells
If A1 cell is having value of “CL3” or “GP1” or “GP2“ or “GP3“ or “GP4“ or “SB1“ or “SB2“ or “SB3“ or “SF1“ or “SF2“ or “SF3“ or “SP1“ or “SP2“ or “TB1“ or “TP1“ or “TP2“ or “TP3” etc. then B1 cell should be locked and same to be filled with red colour and if value other than above then B1 cell to be unlocked for other data input.
Same is applicable to A2, A3, A4…… and B2, B3, B4….. approx.. 500 rows.
Regards,
Pradeep