Paul,

One possibility is to copy the cell with the CF, then at the destination, use Paste
Special - "All except borders". This will cause the loss of the cell contents, as it'll be
overwritten by the paste.

If you're OK with macros, we'll write you one that copies only the CF. I THINK we can. It
can be invoked by a keyboard shortcut, toolbar button, graphic on the sheet.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Paul" wrote in message
...
I want to copy the conditional format of a cell or range of cells, and paste
them to another range of cells, but without changing the default style of the
cell (i.e. I don't want to change the borders)

Any help much appreciated.