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.

Ron,

Copy these coloured cells (Including the numbers) then on the new sheet
select the top-left cell of where you want them to go and then

Edit|Paste Special - Formats OK

Mike

"Ron S." 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.

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.

Thank you for the help. I think I'm headed in the right direction. I'm
working with green for lower valued numbers, yellow for mid-range and red for
higher numbers. When I followed edit|paste special - formats OK, all the
cells became yellow. It didn't continue with red/yellow/green. Thanks.

Ron

"Mike H" wrote:

Ron,

Copy these coloured cells (Including the numbers) then on the new sheet
select the top-left cell of where you want them to go and then

Edit|Paste Special - Formats OK

Mike

"Ron S." 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.

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.