Identifying LOCKED cells

F

FJB0623

Is there a way to identify locked cells, other than going through the processof
looking at each cell's format? Here's by quandry. I am working a worksheet
which has both locked and unlocked cells. Unfortunately some of the locked
cells should be unlocked so that data can be input.

Thanks for your help
To reply to this message, remove "mand" from my address. Thanks
 
D

Dave Peterson

I've dragged the lock button onto a toolbar. When I click on a cell, I can
glance at that and see if it's depressed (not suicidal!) or not.

Tools|Customize|Commands Tab|Format category.
Look for "Lock Cell"

If you're not using Format|conditional formatting, you can use that, too.

Select your range and do
format|conditional formatting
use a formula:
=CELL("protect",A1)
change A1 to the activecell in your selected range.

Give it a nice background/pattern format.

In fact, you could use a helper cell and put an indicator there when you want to
see this formatting:

=and($g$1=1,CELL("protect",A1))

(I put a 1 in G1, then my colors change. I clear it and it's back to normal.)
 
Top