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


.