ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how may I copy color of a other cell (https://www.excelbanter.com/excel-programming/312098-how-may-i-copy-color-other-cell.html)

Thierry[_4_]

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.



Harald Staff

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