View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default conditional formatting

CopyPaste SpecialAllOKEsc

OR just Paste SpecialFormat if that's all you want.


Gord Dibben MS Excel MVP

On Tue, 24 Oct 2006 19:10:02 -0700, hobscons
wrote:

I'm trying to copy a conditionally formatted cell to a cell on another
worksheet and the formatting is not carrying over. What do I need to do?