Forum Discussion
View to show which cells are locked/unlocked
Is there a way to easily view which cells are locked / unlocked without having to go into each one and checking its' format to see if the "Locked Cell" box is ticked?
This would be really handy if you had a view to show this.
6 Replies
Hi Jon,
You can set a conditional formatting rule and apply it to all worksheet to visualize whether a cell is locked or unlocked so that the unlocked cell can be highlighted in a specific format.
To do that:
- Select the triangle in the left-hand corner of the worksheet
- Go to Home >> Styles >> Conditional Formatting >> New Rule
- In the New Formatting Rule dialog box, select Use a formula to determine which cells to format
- Insert this formula into the formula box:
=CELL("protect",A1)=0- Press the Format button to choose the format
- Hit OK
Hope that helps
It works nicely. Could you please explain how that works?
Haytham,
Thank you, I had thought of doing it this way and it will work for my application, however I was looking for a view that would not affect my print (although for my spreadsheet I have picked a very light fill colour).
Grateful for your support.
Cheers
To be able to view the locked cells using this method without affecting the normal formatting, I simply copied the entire sheet to a new tab and did the formatting to highlight the protected cells only in that tab.
