fill color a protected cell without unprotecting worksheet

D

Don Guillett

The archives do not understand blank email bodies so use a meaningful
subject line and then state your question in the body of the post.
Unprotect>color>protect
 
G

Gord Dibben

When you protect the sheet make sure you enable "Format Cells"


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

I can still select & manipulate locked & protected cells in '07 1
How can I merge unprotected cells in a protected worksheet? 1
Excel 2003 - how to check is all worksheet is protected 1
Insert/ delete row in protected worksheet 6
inserting a picture into unprotected cells in a protected excelworksheet 0
Unable to highlight an unprotected cell on a protected sheet. 1
Protecting worksheet. 1
Delete unprotected cells in protected worksheet 1

Top