PasteSpecial with Conditional Formats

Hey All,

I was wondering if it's possible to have PasteSpecial paste conditional formats. I have a range that's background color changes when it's values are within a certain range. I am copying that range to an e-mail, but when it is pasted in the e-mail, the formatted color changes.

Is there anyway to copy the conditional formatted results as well?

Below is the code I have for the copying/pasting portion:

rng.Copy
Set TempWB = Workbooks.Add(1)
With TempWB.Sheets(1)
.Cells(1).PasteSpecial Paste:=8
.Cells(1).PasteSpecial xlPasteValues, , False, False
.Cells(1).PasteSpecial xlPasteFormats, , False, False
.Cells(1).Select
Application.CutCopyMode = False
On Error Resume Next
.DrawingObjects.Visible = True
.DrawingObjects.Delete
On Error GoTo 0
End With

Thanks!

Hi Leith, thanks for your response.

I attached a screenshot and the workbook in question.

When the range is pasted into the e-mail, the conditional formatting is lost. In fact, a completely different color comes up.

Let me know if you have any other questions!!

Hey Leith, it still hasn't fixed it.

Oh that's a very good possibility. I believe our company's Excel is 2007 and Outlook is 2003. I'll have to see about getting them to upgrade. As another option, would it be possible for me to copy the range as a picture and then paste the picture with the e-mail?

I'm assuming to copy I can do

Please Login or Register  to view this content.

but how could I paste that into an e-mail? I've tried toying around with it and cannot get it to work.

Thanks!