Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printed text vs. Screen fonts Dave Excel Discussion (Misc queries) 2 December 6th 08 09:40 PM
First line of cell is cut off when printed (shows on screen) ahaines Setting up and Configuration of Excel 1 September 20th 07 01:56 AM
Words on screen are larger when printed. Jelsing Excel Discussion (Misc queries) 3 June 2nd 07 11:30 PM
Font size on the screen is different when printed Gina Excel Discussion (Misc queries) 2 May 29th 07 07:10 PM
How do I hide words on a printed document, but see on screen? piltricia Excel Discussion (Misc queries) 2 February 15th 06 02:37 AM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"