Do you use Format|Conditional formatting?

If no, then you could do this:

Pick a cell that you can use to indicate that you want to see the colors. I
used $A$1 in this example.

Select your range (say A1:X99)
Then Format|conditional formatting
Formula is: =AND($A$1="show",CELL("protect",A1))

and give it a nice fill color.

Put Show in A1 and you'll see the locked cells. Change A1 and it's back to
normal.


Shrikant wrote:
>
> I want to shade / color locked cells to distinguish them from non-locked
> cells. However I do not wish these shading or colors to be printed. It should
> only for viewing on the screen. How to do it ?
> --
> Shrikant

--

Dave Peterson

Select your range (say A1:X99)
Then Format|conditional formatting
Formula is: =cell("protect",a1)

and give it a nice fill color.

You could even use a cell that would allow you to show it or hide that CF
formatting.

I used $A$1 in this formula:

=AND($A$1="show",CELL("protect",A1))

Put Show in A1 and you'll see the locked cells. Change A1 and it's back to
normal.