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

  • Thread starter Thread starter AA Arens
  • Start date Start date
A

AA Arens

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

Bart

XP/Ex 2003
 
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.
 
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?
 
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.
 
Back
Top