Colors and printing

[Dan wilson]

Good day. I am using Excel 2002 on Windows ME. I have
created a worksheet that contains a number of color-coded
cells to show the user that cells of a certain color have
a particular function. For example, green cells are user
entry, red cells are errors, yellow cells are information
only, etc.

While the worksheet is being completed, the colors are
needed. However, when the user has completed the
worksheet, it is then time to FAX the output to my vendor
for order entry.

Is there a function or a method in which I can temporarily
reformat all of the cells with color into no-color for the
time it takes to print the worksheet or can the worksheet
be printed with no colors by command? The second choice
would be to totally eliminate the colors and leave the end
result completed worksheet as black and white to allow
printing again later if it is needed.

Thanks, Dan...

 

[Earl Kiosterud]

File - Page setup - sheet tab - Black and White. This will render all cell
contents in black, regardless of font color, and all cell backgrounds in
white.

Another option. Paste-link the entire sheet to another sheet, one with no
colors. Fax that sheet.

 

[CLR]

Hi Dan..........

ONe way would be to record a macro that will copy your entire sheet over to
another blank sheet, then delete all background colors from that sheet and
print it instead of your primary colored sheet........then next time, just
fire the macro and it will automatically go through the steps and print the
black and white version....

Vaya con Dios,
Chuck, CABGx3

 

[Dan Wilson]

Good day Chuck and Earl,

Thanks for the response. I will try both methods and see
which works easiest.

Thanks, Danno...

 

[Dan Wilson]

Good day Earl! Wow! How simple. When I first tried your
suggestion below, my screen still showed the colors in the
cells and I thought it wasn't going to work. I decided to
try a printed page and it was all in black and white. I
am impressed! Thank you, you are the master!
Thanks, Danno...