Clara,

Based on your question I think you're not looking for a
programmatically solution...

To do it manually in the interface: select the cells that are already
formatted an,d select Edit/Copy then select the range you want to
format the same and select Edit/Paste Special, choose formatting and
click OK.
If you turn the macro recorder on you can see haw to do this
programmatically.

DQ