Same format using =

S

stabilo

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
 
P

Peter Rooney

Stabilo,

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

Hope this helps

Pete
 
S

stabilo

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

Gord Dibben

stabilo

Formulas cannot format cells. They can only return values.

You could use Conditional Formatting or VBA


Gord Dibben Excel MVP
 
Top