| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Moving Cell Formats
If I have one cell = the contents of another cell. Is there a way that I can
have the colours and formatting of that cell match? I have 1 sheet where it lists information, and on another sheet it will just be an =cell of the right cell information on the other sheet. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Moving Cell Formats
Not by formula.
Linked cells return results only, not formatting. You could copy/paste special/formats as a workaround. Gord Dibben MS Excel MVP On Mon, 23 Jul 2007 09:42:05 -0700, Chart_Maker_Wonderer wrote: If I have one cell = the contents of another cell. Is there a way that I can have the colours and formatting of that cell match? I have 1 sheet where it lists information, and on another sheet it will just be an =cell of the right cell information on the other sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
| Force user to enter data in cell before moving to next cell | New Users to Excel | |||
| Entire worksheet moves when moving from cell to cell | Excel Discussion (Misc queries) | |||
| Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel | |||
Linear Mode
