Thank's for your help. Even though I didn't use your idea, it made me think
more in the font area. I changed the font for all the numbers on the page
to size one. The numbers are now so small they appear as a mark on the
colored background. I know this isn't the way it should be done, but it is a
quick fix for me. Thanks again.

"Gord Dibben" wrote:

If the colors are due to Conditional Formatting you would need some VBA to
copy just the colors.

Or copy the entire worksheet and set the font to same color as background.

If manually colored see Mike's reply.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 11:43:24 -0700, Ron S. <Ron
wrote:

I have one worksheet with numeric values. Each cell is color coded based on
the difference from the average from that particular value. How can I make a
second worksheet that just has the color and not the numbers? I am using
Excel 2003. Thank you.