Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Format Unlocked Cells
Excel 2007
We have a worksheet that is protected. The worksheet contains some unlocked cells so that people can add data to the file. I've been asked to find a way to format the cells that require a value so that people who are unfamiliar with the file will be able to figure it out. Somehow, the tab named Instructions, which contains full instructions for entering data into the file, is not sufficient for management. ;-) Is there a way to conditionally format only cells that are unlocked? --Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Format Unlocked Cells
Use this formula in your Conditional Formatting Rule:
=CELL("protect",A1)=0 Where A1 is the active cell in the range that you have selected to apply the conditional formatting to. HTH Elkar "Thomas M." wrote: Excel 2007 We have a worksheet that is protected. The worksheet contains some unlocked cells so that people can add data to the file. I've been asked to find a way to format the cells that require a value so that people who are unfamiliar with the file will be able to figure it out. Somehow, the tab named Instructions, which contains full instructions for entering data into the file, is not sufficient for management. ;-) Is there a way to conditionally format only cells that are unlocked? --Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Conditionally Format Other Cells or Rranges | Excel Discussion (Misc queries) | |||
How can I format unlocked cells when the work sheet is protected | Excel Discussion (Misc queries) | |||
Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
How can I conditionally format cells that contain formulas? | Excel Discussion (Misc queries) | |||
conditionally format cells | Excel Worksheet Functions |