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

[Sheldon]

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

 

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

 

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