Paste Special Formats Generated by Conditional Formatting

[Guest]

I want to paste special the values and format of a cell to another cell, but
I do not want to bring the conidtional formatting logic with it. When I
paste special values, and format, it brings the conditional formatting logic
and hence does not give me the formatting I want in the new cell location.
Is it possible to paste special formats without bringing conditional
formatting logic.

Thanks

 

[Don Guillett]

did you look at all of the options of paste pastespecial

 

[KellTainer]

you could use paste special-> formulas/values and number formats o
other options to do the copy

 

[Guest]

Sorry let me be clearer. The format in question is the cell interior colour.
There does not seem to be an option to copy the interior colour over with
the conditional formatting link severed.

EM

 

[KellTainer]

I edited the post earlier after realising what you needed. Just paste
the values normally, then use the macro vba i posted above to clean the
conditional formatting up. 2 step process ^^

 

[Guest]

Sorry I did not see any code in the previous post.

EM

 

[KellTainer]

Weird, but anyway

Sub ClearConditionalFormatting()
Selection.FormatConditions.Delete
End Sub

attach this vba macro to a keyboard shortcut for easy use. then selec
and apply