ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Highlight a range for data entry (https://www.excelbanter.com/excel-discussion-misc-queries/107325-highlight-range-data-entry.html)

Kirk P.

Highlight a range for data entry
 
I would like to highlight a range (grey or yellow) to indicate to the user
that some data entry must be performed in those cells, but I DON'T want the
color to appear when the spreadsheet is printed.

Can I do something like this?


Kevin B

Highlight a range for data entry
 
You can set the printer's color option to black and white. When you're ready
to print, click FILE in the menu, select PRINT and click the PROPERTIES
button to set the properties for the printer.


--
Kevin Backmann


"Kirk P." wrote:

I would like to highlight a range (grey or yellow) to indicate to the user
that some data entry must be performed in those cells, but I DON'T want the
color to appear when the spreadsheet is printed.

Can I do something like this?


Kirk P.

Highlight a range for data entry
 
Even in black and white, the highlighted cells print in shades of grey. I'm
looking for the highlighted cells to print as if they were not highlighted at
all.

Basically highlighted on the screen, but not on the print-out.

"Kevin B" wrote:

You can set the printer's color option to black and white. When you're ready
to print, click FILE in the menu, select PRINT and click the PROPERTIES
button to set the properties for the printer.


--
Kevin Backmann


"Kirk P." wrote:

I would like to highlight a range (grey or yellow) to indicate to the user
that some data entry must be performed in those cells, but I DON'T want the
color to appear when the spreadsheet is printed.

Can I do something like this?



All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com