Since the response was pretty small, you could have written it down on a piece
of paper/napkin.

Or you can use google to search for stuff you've posted (and find the replies,
too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_gr...Excel*&num=100

Shrikant wrote:

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.


--

Dave Peterson