Colors and printing
 

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

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dan wilson" wrote in message
...
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...

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" wrote in message
...
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...

Good day Chuck and Earl,

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

Thanks, Danno...

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

-----Original Message-----
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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dan wilson" wrote in message
...
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...


.