copy cell A1, paste special formats onto A5.

"stabilo" wrote in message
...
I have a cell (let's say A1), that is formatted with a fill color, a
specific
font, and a specific font color. I have another cell (A5) that has the
formula =A1. How can A5 have the same formatting as A1 and not only its
value
? thnks