How To Indicate Which Cells In A Sheet Are Locked and Protected

S

Sheldon

Is there a way to easily indicate which cells in a sheet are both
locked and protected?
Sheldon Potolsky
 
D

Dave Peterson

I'm not sure what locked and protected means, but if you're not using
conditional formatting for anything, you can use it for this:

Select your range (all the cells)

(I had A1 the activecell.)

Format|conditional formatting (xl2003 menus)
formula is:
=cell("Protect",a1)=1

Give it a nice shade.
 
S

Sheldon

Thank you Dave.
Sheldon

I'm not sure what locked and protected means, but if you're not using
conditional formatting for anything, you can use it for this:

Select your range (all the cells)

(I had A1 the activecell.)

Format|conditional formatting (xl2003 menus)
formula is:
=cell("Protect",a1)=1

Give it a nice shade.
Click to expand...
 
Top