| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell and the font color | Excel Discussion (Misc queries) | |||
| formating the color and border of a cell and then copy numbers int | Excel Discussion (Misc queries) | |||
| Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell | Excel Worksheet Functions | |||
| How can I copy down, the contents of a cell and not color | Excel Discussion (Misc queries) | |||
| In a function, How do I copy the cell color as well as text | Excel Worksheet Functions | |||
![Thierry[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
