Drag value not format?!



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

.