Hello all,

I am working on a spreadsheet task and a case arises when a user
selects a cell(or some cells) then drag the fill handle to copy data or
fill adjacent cells with a series of data. However it causes the
orignal cell/s' formatting will be copied to the destination cell/s
too, i.e. the conditional formatting previous imposed on the
destination block will be overwritten by the origin's. Is there any way
to allow for only value copying but NOT formatting so any existing
conditional formating will be able to survive?

Thanks in advance and have a wicked Easter!
Frank

Use Copy/ Paste Special/ Pick what you want-- values only, formulas
only, etc. ed

Thanks ed for you reply. The solution using 'Paste Sepcial' works well
for copy and paste scenario, but not for the case in which the user
drags the fill handle to copy data/formula.

The problem remains open.

Regards
Frank