Thanke Dave. Yr reply answered my query.
I am at public i cafe and wanted to mail it to my inet account so that
later on I can use your reply to solve my problem. Alternatively, can I
'bookmark' this reply so that lateron I can easily return it for use. You
know this site is flooded with questions and my solitary entry will get
drowned - making it difficult to locate it later on.
This is out of the main topic. But very much relevant for me.
--
Shrikant


"Dave Peterson" wrote:

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