Conditionally Format Unlocked Cells

T

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top