Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Reference another cell's content including its format
Im trying to reference a cell's content including it's format in a different
cell. I cannot seem to figure out how to reference a cell format or its color. Example: I have a cell with a number and the cell is yellow. I refernce this cell on another sheet within the workbook and I can see the number but the cell is white not yellow. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Reference another cell's content including its format
When you reference another cell through a formula formatting does not pass
through So if B1 contains 10 and is yellow then A1 having =B1 formula will get 10 but not the formatting. "Brian D" wrote: Im trying to reference a cell's content including it's format in a different cell. I cannot seem to figure out how to reference a cell format or its color. Example: I have a cell with a number and the cell is yellow. I refernce this cell on another sheet within the workbook and I can see the number but the cell is white not yellow. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Reference another cell's content including its format
If the source cell is formatted yellow due to Conditional Formatting, you
could use the same CF on the target cell. Gord Dibben MS Excel MVP On Fri, 14 Nov 2008 15:17:00 -0800, Brian D <Brian wrote: Im trying to reference a cell's content including it's format in a different cell. I cannot seem to figure out how to reference a cell format or its color. Example: I have a cell with a number and the cell is yellow. I refernce this cell on another sheet within the workbook and I can see the number but the cell is white not yellow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing an active cell's content from another sheet. | Excel Worksheet Functions | |||
Replacing Part of a Cell's Content | Excel Worksheet Functions | |||
Need to refer to a cell's address, not it's content... | Excel Discussion (Misc queries) | |||
Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) |