Conditionally Format Unlocked Cells

[Thomas M.]

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

 

[Elkar]

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