| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I reffer a cell format from other cell?
I would like to reffer other cells color format to reffered cell.
If I put " =A2 " on cell B2, only value on cell A2 copyed to cell B2. Can somebody help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I reffer a cell format from other cell?
You can not get another cells format using a formula.
You can copy and paste the format through Paste Special but it won't change based on the formula result. You can have upto 3 (Excel 2003 and earlier) formats based on cell value or formula based on cell value... "Kaz" wrote: I would like to reffer other cells color format to reffered cell. If I put " =A2 " on cell B2, only value on cell A2 copyed to cell B2. Can somebody help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
