A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Highlight cell on screen but not when printed?



 
 
Thread Tools Display Modes
  #1  
Old February 4th 09, 09:11 PM posted to microsoft.public.excel.misc
travis
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.
Ads
  #2  
Old February 4th 09, 10:23 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,912
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  
Old February 5th 09, 06:51 PM posted to microsoft.public.excel.misc
travis
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  
Old February 5th 09, 08:41 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,912
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.

>>
>>


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printed text vs. Screen fonts Dave Excel Discussion (Misc queries) 2 December 6th 08 08: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 01:37 AM


All times are GMT +1. The time now is 07:38 AM.


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