how may I copy color of a other cell

T

Thierry

Hello,
I need a function that copy also the full format/color/size of a cell
Example
A1 = USD 12'500.00 (monetary size, 12 fat, blue bottom)
A2 = mon 12.03.2004 (dates, 10 not fat, white bottom)
If in A3 I type: =" A1 " I would like a blue bottom, 12 fat, etc. and
If I type =" A2 " a white bottom, 10 not fat, etc....
Is it possible?
Thank you for any help.
 
E

Earl Kiosterud

Thierry,

Maybe you can use the Format Painter. Select the cell that has the
formatting you wish to copy, and click the Format Painter. It's a
paintbrush on a button on the Standard toolbar. Now click the cell that's
to be formatted, and the formatting is copied. If you double-click the
painter, you can click many cells, applying formatting. Then turn it back
off by either clicking it again, or pressing Esc.
 
Top