| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colour formatting that doesn't show up when printing
I want to be able to format various input cells in different colours so that
for example one user inputs data in the blue cells and another inputs data in the yellow cells. However, I want these colours only to appear when viewed on screen and not when printed. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour formatting that doesn't show up when printing
File/Page Setup/Sheet/Print in Black and white
Regards, Stefi duffbauer ezt *rta: I want to be able to format various input cells in different colours so that for example one user inputs data in the blue cells and another inputs data in the yellow cells. However, I want these colours only to appear when viewed on screen and not when printed. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour formatting that doesn't show up when printing
I can do that but it's no good to me because the cell still appears shaded
(greyscale). What I need is colour when viewing it but a complete absence of any colour or shading when printing it. "Stefi" wrote: File/Page Setup/Sheet/Print in Black and white Regards, Stefi duffbauer ezt *rta: I want to be able to format various input cells in different colours so that for example one user inputs data in the blue cells and another inputs data in the yellow cells. However, I want these colours only to appear when viewed on screen and not when printed. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour formatting that doesn't show up when printing
You probably have some other problem! I've checked again and it works.
Perhaps you have not only background colour but also fill pattern set. Regards, Stefi duffbauer ezt *rta: I can do that but it's no good to me because the cell still appears shaded (greyscale). What I need is colour when viewing it but a complete absence of any colour or shading when printing it. "Stefi" wrote: File/Page Setup/Sheet/Print in Black and white Regards, Stefi duffbauer ezt *rta: I want to be able to format various input cells in different colours so that for example one user inputs data in the blue cells and another inputs data in the yellow cells. However, I want these colours only to appear when viewed on screen and not when printed. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show or hide formatting marks | Excel Worksheet Functions | |||
| how can I format to show different colour after edit | Excel Discussion (Misc queries) | |||
| Formatting Pivot Table- when doble clicking to show Detail | Excel Discussion (Misc queries) | |||
| Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
