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