S
Sticker
How can I make Excel 97 show protected cells, perhaps display them in
a different color?
a different color?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.
(say A1:Z999) and with A1 the activecell:
Format|conditional formatting|
Formula is: =cell("protect",a1)
And format the way you want.
S
Sticker
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.
That doesn't seem to work.
M
Max
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 ..
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 ..
S
Sticker
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.
M
Max
Sticker said:I got it work. I wasn't doing it right. Thanks guys.
Glad to hear that you got it working <g>