Maintain conditional formatting after changing cell contents

[rodwhiteley]

Hey All,
I have a matrix with conditional formatting of some values that looks like this: http://1drv.ms/1xx9Ckr http://1drv.ms/1xx9Ckr
then I want to add some other data to the fields (standard deviations, and descriptors) so of course the conditional formatting is now stripped out: http://1drv.ms/1F2o9MT
http://1drv.ms/1F2o9MT
Ultimately this table will end up in a MS Word document, so I can simply copy and paste, then manually type in the extra values, however I wonder is there a way to paste the conditional formatting (data bars, and gradient colour background fills) from the first table "over the top" of the second table?
Thanks for any help,
Rod

 

[rodwhiteley]

<Bump>