How can I make Excel 97 show protected cells, perhaps display them in
a different color?

If you're not using Format|conditional formatting, you could select your range
(say A1:Z999) and with A1 the activecell:

Format|conditional formatting|
Formula is: =cell("protect",a1)
And format the way you want.



Sticker wrote:
>
> How can I make Excel 97 show protected cells, perhaps display them in
> a different color?

--

Dave Peterson
(E-Mail Removed)

On Sun, 19 Sep 2004 20:05:13 -0500, Dave Peterson <(E-Mail Removed)>
wrote:

>If you're not using Format|conditional formatting, you could select your range
>(say A1:Z999) and with A1 the activecell:
>
>Format|conditional formatting|
>Formula is: =cell("protect",a1)
>And format the way you want.
>
>
>
>Sticker wrote:
>>
>> How can I make Excel 97 show protected cells, perhaps display them in
>> a different color?

That doesn't seem to work.

> That doesn't seem to work ..

Dave's suggestion works fine for me (I'm using xl97)

Maybe try unprotecting the sheet first, then apply
the conditional formatting as suggested by Dave

(the protected cells in the selected range will appear as formatted)

And then re-protect the sheet ..

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
"Sticker" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sun, 19 Sep 2004 20:05:13 -0500, Dave Peterson <(E-Mail Removed)>
> wrote:
>
> >If you're not using Format|conditional formatting, you could select your
range
> >(say A1:Z999) and with A1 the activecell:
> >
> >Format|conditional formatting|
> >Formula is: =cell("protect",a1)
> >And format the way you want.
> >
> >
> >
> >Sticker wrote:
> >>
> >> How can I make Excel 97 show protected cells, perhaps display them in
> >> a different color?
>
>

On Mon, 20 Sep 2004 10:36:36 +0800, "Max" <(E-Mail Removed)>
wrote:

>> That doesn't seem to work ..
>
>Dave's suggestion works fine for me (I'm using xl97)
>
>Maybe try unprotecting the sheet first, then apply
>the conditional formatting as suggested by Dave
>
>(the protected cells in the selected range will appear as formatted)
>
>And then re-protect the sheet ..

I got it work. I wasn't doing it right. Thanks guys.

"Sticker" <(E-Mail Removed)> wrote
> I got it work. I wasn't doing it right. Thanks guys.

Glad to hear that you got it working <g>

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----