Is there any way to make unlocked cells visible when the sheet is locked?

[AA Arens]

Is there any way to make unlocked cells visible when the sheet is
locked?

Bart

XP/Ex 2003

 

[AA Arens]

Is there any way to MARK unlocked cells visible when the sheet is
locked?

 

[Dave Peterson]

One way if you're not using format|conditional formatting, you could select
the cells (all of them???) and with A1 the the activecell:

Format|conditional formatting
formula is: =cell("protect",a1)
Give it a nice format.

 

[AA Arens]

It goes in the right directed, i guess.
how to cond format the cells who are not locked. The idea is that
other people should know in which cells they have to fill in a value,
namely on the unlocked cells. The sheet is protected.
And, the marks of the unlocked cells (given by conditional
formatting?) should not be printed, while other formats has.

How to perform?

 

[Dave Peterson]

You can use:
=CELL("protect",A1)=0
to highlight the cells that are unlocked.

To keep from printing those shades, you can pick out a cell to use as an
indicator.

I used $A$1 because it's usually easy to find and modify.

Use a conditional formatting formula of:
=AND($A$1<>"",CELL("protect",A1)=0)

And to see the shading, put something in A1. To hide the shading, erase the
contents of A1.