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.
Earl Kiosterud - 30 Sep 2004 23:17 GMT
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.

Signature
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
> Hello,
> I need a function that copy also the full format/color/size of a cell
[quoted text clipped - 5 lines]
> Is it possible?
> Thank you for any help.