![]() |
how may I copy color of a other cell
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. |
how may I copy color of a other cell
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 "Thierry" skrev i melding ... 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. |
All times are GMT +1. The time now is 02:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com