Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cell on screen but not when printed?
I'd like to be able to highlight cells in my spreadsheet to call attention to
someone working in the spreadsheet, but I'd like it to be invisible to the reader of the printed schedule. Is that possible? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cell on screen but not when printed?
Assuming highlight means to color the cells.........
Set print options to Black and White Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:11:12 -0800, Travis wrote: I'd like to be able to highlight cells in my spreadsheet to call attention to someone working in the spreadsheet, but I'd like it to be invisible to the reader of the printed schedule. Is that possible? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cell on screen but not when printed?
Thanks Gord, but that's not really what I meant. That would just give me a
gray highlight rather than a colored highlight on the printed result. An example of what I want to do is to color certain cells, say, green. When one of my employees uses my excel model, she will know that all input variables are highlighted in green, and that she is free to change the values in these cells. She will also know not to make any changes to cells that aren't green, because those cells contain formulas or constants. Our clients don't see the excel model -- they only see the printed results. The distinction between variables, constants and formulas is not important to our clients, only to me and my employees. Consequently, I don't want anything showing up on the printed results that indicates the distinction. In short, I want a shorthand visual means (in this case, color-coding) of communicating something only to the excel user and not to the person viewing the printed results. "Gord Dibben" wrote: Assuming highlight means to color the cells......... Set print options to Black and White Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:11:12 -0800, Travis wrote: I'd like to be able to highlight cells in my spreadsheet to call attention to someone working in the spreadsheet, but I'd like it to be invisible to the reader of the printed schedule. Is that possible? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight cell on screen but not when printed?
I don't get a gray highlight when I print in Black and White so my printer
setup must be different. I guess you could always copy the sheet then clear the highlighted cells and change all formulas to values. Print that for the clients. You could automate by recording a macro. Or protect the sheet with only those user cells unlocked and selectable. User can Tab to unlocked cells and edit those only. Gord On Thu, 5 Feb 2009 10:51:36 -0800, Travis wrote: Thanks Gord, but that's not really what I meant. That would just give me a gray highlight rather than a colored highlight on the printed result. An example of what I want to do is to color certain cells, say, green. When one of my employees uses my excel model, she will know that all input variables are highlighted in green, and that she is free to change the values in these cells. She will also know not to make any changes to cells that aren't green, because those cells contain formulas or constants. Our clients don't see the excel model -- they only see the printed results. The distinction between variables, constants and formulas is not important to our clients, only to me and my employees. Consequently, I don't want anything showing up on the printed results that indicates the distinction. In short, I want a shorthand visual means (in this case, color-coding) of communicating something only to the excel user and not to the person viewing the printed results. "Gord Dibben" wrote: Assuming highlight means to color the cells......... Set print options to Black and White Gord Dibben MS Excel MVP On Wed, 4 Feb 2009 13:11:12 -0800, Travis wrote: I'd like to be able to highlight cells in my spreadsheet to call attention to someone working in the spreadsheet, but I'd like it to be invisible to the reader of the printed schedule. Is that possible? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printed text vs. Screen fonts | Excel Discussion (Misc queries) | |||
First line of cell is cut off when printed (shows on screen) | Setting up and Configuration of Excel | |||
Words on screen are larger when printed. | Excel Discussion (Misc queries) | |||
Font size on the screen is different when printed | Excel Discussion (Misc queries) | |||
How do I hide words on a printed document, but see on screen? | Excel Discussion (Misc queries) |