Colour formatting that doesn't show up when printing

D

duffbauer

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?
 
S

Stefi

File/Page Setup/Sheet/Print in Black and white

Regards,
Stefi


„duffbauer†ezt írta:
 
D

duffbauer

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.
 
S

Stefi

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:
 
Top