View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Unprotected cells

You could use conditional formatting to set the colour if the cell is
blank (eg bright yellow), but once the users have typed something in,
the cell reverts to a non-coloured background.

Hope this helps.

Pete

On Oct 13, 2:16*am, Mainer wrote:
i have a form that needs input in some cells and then needs to be printed.. I
would like to color those cells so the user knows which cells they can change
but i dont want the colors to show up when i print the form