how may I copy color of a other cell

[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.

 

[Harald Staff]

Hi

No, a formula can only return a value, no formats or actions.
Quote my old hero Frank Zappa: "No dancing, no fun, sit down !"

Best wishes Harald