Condtional Format Based on Cell Protection

Nimrod · May 8th, 2002, 02:24 PM

Hi Matti:
RE: conditional format base on LOCKED cell

If you are going to have the formula cells locked then there is another way to change the text color without a macro.
You can do a "conditional format" based on if a cell is locked or not !

1-Go into Format ... conditional format..
2-choose "formula is" from drop down
3-type in this formual : =CELL("protect")=0
4-make your format choices
5-select add button
6-type in this formula: =CELL("protect")=1
7-make your format choices

Done : now you have a special format for lock=1, and unlocked = 0

James · May 8th, 2002, 02:29 PM

Nimrod:

I like your "Note: Tested on blah,blah,blah"
maybe we should all be adding that to our post

James

Carp · Feb 5th, 2004, 09:06 AM

Hi Nimrod

Maybe this is too old but I feel it’s best to say that your
solution is very volatile. I’ve tried it on a new workbook
with nothing else in it and it’s switching back and forth
between the two formats… seemingly at random.

May 8th, 2002, 02:24 PM	#1
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Hi Matti: RE: conditional format base on LOCKED cell If you are going to have the formula cells locked then there is another way to change the text color without a macro. You can do a "conditional format" based on if a cell is locked or not ! 1-Go into Format ... conditional format.. 2-choose "formula is" from drop down 3-type in this formual : =CELL("protect")=0 4-make your format choices 5-select add button 6-type in this formula: =CELL("protect")=1 7-make your format choices Done : now you have a special format for lock=1, and unlocked = 0 __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Feb 5th, 2004, 09:06 AM	#3
Carp New Member Join Date: Dec 2003 Posts: 48	Re: Condtional Format Based on Cell Protection Hi Nimrod Maybe this is too old but I feel it’s best to say that your solution is very volatile. I’ve tried it on a new workbook with nothing else in it and it’s switching back and forth between the two formats… seemingly at random.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 02:29 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Nimrod: I like your "Note: Tested on blah,blah,blah" maybe we should all be adding that to our post James