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

Stabilo,

Select A1
Edit-Copy
Select A5
Edid-Paste Special-Formats-OK

Hope this helps

Pete





"stabilo" wrote:

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

oops sorry I was not clear. In fact it is a rather complex spreadsheet and it
has to be on a formula

"Peter Rooney" wrote:

Stabilo,

Select A1
Edit-Copy
Select A5
Edid-Paste Special-Formats-OK

Hope this helps

Pete





"stabilo" wrote:

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

stabilo

Formulas cannot format cells. They can only return values.

You could use Conditional Formatting or VBA


Gord Dibben Excel MVP

On Tue, 14 Jun 2005 08:29:02 -0700, "stabilo"
wrote:

oops sorry I was not clear. In fact it is a rather complex spreadsheet and it
has to be on a formula

"Peter Rooney" wrote:

Stabilo,

Select A1
Edit-Copy
Select A5
Edid-Paste Special-Formats-OK

Hope this helps

Pete





"stabilo" wrote:

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

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