Chip Pearson has some info he
http://www.cpearson.com/Excel/CFColors.htm
But it's not for the faint of heart.

========

I've used this manual technique in the past.

Open excel (and the workbook)
Open MSWord
Select a range in excel and copy|paste into word.
The CF stuff is kept.
Copy and paste back into a new workbook/new worksheet.

Repeat as many times as you need.

========
Maybe you could save/print the file as a .pdf. I use www.primopdf.com to create
pdf's.

Maybe you could copy the ranges and paste into a new workbook/worksheet as a
picture.
Select the range
Edit|copy
Select the destination location
Shift-edit|Paste picture



Rob wrote:

I searched all over the community to see if I can find what I am looking for
but I either missed it or it isn't available. What I am trying to do is,
with VB, copy an entire worksheet and then paste it back into the same
worksheet BUT only the values and all formattings... except I want the
conditional formats to actually be converted from conditional formatting to
actual formatting.

In other words, with the original uncopied data the conditional formats have
formulae in it to do the coloring. When it is copied I want it to still have
the coloring applied as it was/is but not actually have conditional
formatting to color it.

I've tried all sorts of ways with the pastespecial xlvalues/xlformats/etc.
but nothing gets rid of the conditional formats and yet still keep the
coloring.

Is this possible?

Thanks In Advance!
Rob

--

Dave Peterson