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

did you look at all of the options of paste pastespecial

--
Don Guillett
SalesAid Software

"ExcelMonkey" wrote in message
...
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

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


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544293

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" wrote:


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


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544293

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 ^^


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544293

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

EM

"KellTainer" wrote:


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 ^^


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544293

Weird, but anyway

Sub ClearConditionalFormatting()
Selection.FormatConditions.Delete
End Sub

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


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544293