S Sticker Sep 20, 2004 #1 How can I make Excel 97 show protected cells, perhaps display them in a different color?
D Dave Peterson Sep 20, 2004 #2 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.
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.
S Sticker Sep 20, 2004 #3 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. Click to expand... That doesn't seem to work.
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. Click to expand... That doesn't seem to work.
M Max Sep 20, 2004 #4 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 ..
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 ..
S Sticker Sep 20, 2004 #5 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 .. Click to expand... I got it work. I wasn't doing it right. Thanks guys.
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 .. Click to expand... I got it work. I wasn't doing it right. Thanks guys.
M Max Sep 20, 2004 #6 Sticker said: I got it work. I wasn't doing it right. Thanks guys. Click to expand... Glad to hear that you got it working <g>
Sticker said: I got it work. I wasn't doing it right. Thanks guys. Click to expand... Glad to hear that you got it working <g>
