If you look at Review tab > Changes group > Protect sheet, you'll find the dialog box has a lot of tick options, including one to allow the user to format cells. Tick that one, and they should be able to change the colour even if the cell is protected.
Kind Regards,
Out of the Hat
"Computers are stupid - they do EXACTLY what you tell them to"
If I've helped you with a problem, please say thanks by clicking the small star icon on the left.
Thank you, that works perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks