Hi pakistanray,
Paragraph Styles should be used to manage anything to do with text formatting (including text background colour). Used correctly, there's then nothing in that regard to copy - simply re-apply the desired Style to the relevant cells. As for cell attributes (borders, shading etc), I think you'd need a macro to do the replication.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|