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
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