thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 917
- Office Version
- 365
- Platform
- Windows
Is there a way to lock color formats of cells so that they can not be changed?
-twg
-twg
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Locking Color Formats?
- Thread starter thewiseguy
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Have you tried protecting the worksheet?
Upvote
0
thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 917
- Office Version
- 365
- Platform
- Windows
yes but I don't want to lock the entire worksheet...just certain areas.
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Sorry, it's not possible to allow formatting of only unlocked cells.
Upvote
0
clipro
Board Regular
- Joined
- Jan 12, 2005
- Messages
- 195
it is a stupid way but you can use conditional formatting - for the most of common users it will be impossible to change the color. Put as a condition some ever valid formula like this =IF(ISNONTEXT(B6)=TRUE,ISNONTEXT(B6),TRUE)
is it helpful?
is it helpful?
Upvote
0
