View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thomas M. Thomas M. is offline
external usenet poster
 
Posts: 68
Default 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