Protecting conditional formatting

P

Phil20031

Hi,

On Excel 2003 is there a way to protect conditional formatting and still
allow information to added to the cell?

Thank you
 
P

Phil20031

Hi Bob, sorry I wasn't more specific, I'll explain... I have a range of cells
set up that change colour depending on the value entered in them, however,
the problem is that some users are changing the formatting setup so if
possible I would like to be able to lock or disable the formatting option
once I've reset the CF values. Can you help me?

Thank you

Phil
 
G

Gord Dibben

You can unlock the cells for data input then protect the sheet with a
password.

Users won't be allowed to "format cells" and the CF will be grayed out.

Note: Excel internal security is quite weak and passwords easily cracked.


Gord Dibben MS Excel MVP
 

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

Protecting Word 2019 document 0
Crating User Form to Add Names 1
Mail Merge Directory Conditional Page Break 0
Conditional Formatting and Formulas 1
protect conditional formatting 2
Conditional formatting disappears when cell contents deleted 2
Conditional Format Entire Workbook 1
Conditional Formatting question.... 1

Top