How do you shade in an unlocked cell on a protected worksheet?

[Guest]

If you have protected a worksheet, how can you highlight an unprotected cell
on that worksheet?

 

[Dave Peterson]

Are you Dave?

You could use Format|Conditional formatting.

Select your range (I used A1:X99)
then with A1 the active cell
Format|conditional formatting
formula is: =CELL("protect",A1)=0

Format it nicely.

If you're Dave, you have a response at your first version of this post.