View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pkeegs pkeegs is offline
external usenet poster
 
Posts: 46
Default Pasting into a cell with conditional formatting

Users of my worksheet (Excel 2003) occasionally manually copy data from one
sheet into a sheet with conditional formatting. It requires them to
'pastevalues'. Some users forget and simply 'paste' the data which deletes
the conditional formatting. Is there any way that I can protect the formats
so that if they 'paste', a dialogue box will indicate that they need to
'pastevalues'?