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