Same format using =

[Guest]

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

 

[Guest]

Stabilo,

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

Hope this helps

Pete

 

[Bob Umlas]

copy cell A1, paste special formats onto A5.

 

[Guest]

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

 

[Gord Dibben]

stabilo

Formulas cannot format cells. They can only return values.

You could use Conditional Formatting or VBA


Gord Dibben Excel MVP