Protecting sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I protect a sheet from format changes, but still be able to change cell
color? I am using Excel 2000.
 
TV

Cell color is a format.

Conditional formatting will work on any cells you have set to be "unlocked"
even when the sheet is protected.

Otherwise you would need to use VBA to unprotect the sheet, make the color
change then re-protect.

Do you want to go this route?

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protect cell format 1
Excel Move or Copy Stopped Working? 0
David Biddulph is correct 8
Hidden cells 2
Protecting Cell loses formatting 2
Protect Worksheet to share with older versions of excel 2
Excel Protection 2
Hiding Formulas and Being Able to Make Changes 2

Back
Top