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 y...

excel

Haytham Amairah

Silver Contributor

Sep 20, 2018

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: