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

  • Thread starter Thread starter Sheldon
  • Start date Start date
S

Sheldon

Is there a way to easily indicate which cells in a sheet are both
locked and protected?
Sheldon Potolsky
 
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.
 
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...
 
Back
Top