Copy Conditional Formatting To Other Sheet

[bigfoot]

hi folks
i have a table that i filter on column A, and then copy the visible cells, through column CR, to another sheet, in the same workbook. im trying to copy filtered cells, in the state that they are in, based on the conditional formatting, to another sheet. the formatting of the pasted cells are not the same as the copied cells. what am i doing wrong? is there a remedy for this? i appreciate any help offered.

 

[Desu Nota from Columbus]

when you paste them, a little clip board should pop up right next to the paste. Click on it and select keep source formatting

 

[bigfoot]

thanks, but that apply to excel 2003. i tried copying the data, manually, and i didnt see the box appear. plus, can that be worked into vba code, as part of the copy process?

 

[Desu Nota from Columbus]

what version of excel are you using?

my default copy/paste keeps the conditional formatting.

I recorded this macro of me copying column A of sheet 1,

to column B of sheet 3 (pasted values and source formatting)

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 7/20/2011 by
'

'
    Columns("A:A").Select
    Selection.Copy
    Sheets("Sheet3").Select
    Columns("B:B").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
End Sub

 

[bigfoot]

i am using excel 2003. i should apologize for the confusion i caused. what i am trying to copy is the result of the conditional format, not the conditional format itself. since the formatting references a cell that is not available on the "receiving" sheet, it reverts to condition 1. what i want is the exact formatting on the original sheet,without the conditions being copied, ad the formatting not changing at all. thank you.