Showing locked/unlocked cells

[Dewi...]

I have created a worksheet and only the user input cells are unlocked.

Is there a quick way to see which cells are locked and unlocked, this
for me to see which I have missed, if any.

Many thanks

 

[Pete_UK]

I don't know of any automatic way to do this, but I use a bright
yellow background to indicate cells where Users can input data (i.e.
the unlocked cells), and then it is easy to communicate to them that
they can enter data wherever the cell is yellow. I colour them
manually.

Hope this helps.

Pete

 

[Dave Peterson]

Are you using format|Conditional formatting?

If no, maybe you can use it for this.

Select your range (A1:X9999)
With A1 the active cell,
Format|conditional format
Formula is: =CELL("protect",A1)=1
and give it a nice pattern
to highlight the cells that are locked.

To keep from printing those shades, you can pick out a cell to use as an
indicator.

I used $A$1 because it's usually easy to find and modify.

Use a conditional formatting formula of:
=AND($A$1<>"",CELL("protect",A1)=1)

And to see the shading, put something in A1. To hide the shading, erase the
contents of A1.

 

[RookieDave]

Hi Dave so is this two separate conditions or only one?