Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unprotected cells
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unprotected cells
Another option is to use CF with a text string which wil never be used
Formatconditional FormattingCondition1 'Cell Value Is' 'not equal to' in the third box type "~~~~" and select a fill color If this post helps click Yes --------------- Jacob Skaria "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected/Unprotected Cells | Excel Discussion (Misc queries) | |||
Printing Unprotected Cells Only | Excel Discussion (Misc queries) | |||
tab between unprotected cells | Excel Discussion (Misc queries) | |||
Modifying UnProtected Cells | Excel Discussion (Misc queries) | |||
Unprotected cells after a download | Excel Discussion (Misc queries) |