Why not format and unlock at the same time by assigning a style ... Click the Review tab and then click Protect Sheet in the Changes group. (In Excel 2003, choose Protect from the Tools menu ...