Excel Can you lock the value of a cell but not the format?

M

mmfansler

Joined
Apr 20, 2017
Messages
1
Reaction score
0
I am creating a status document. I want to lock the number value in a cell but allow the users to change the color format or fill of the cell. Is this possible?
 
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Yep you can do that. On the ribbon select the Review tab, and then click on Protect Sheet. It will then take you to an option box where you can add a password and specify what you want users to be able to do.

Welcome to the forum! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Excel In Excel how can I block the contenent of a cell? 0
Excel Conditional Formatting 1
Excel Need Countifs Formula Help 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel Named Ranges and Conditional Format 3

Top