Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell e.g. A1 which contains data e.g 123 which is formatted in red.
When I refer to that cell from e.g B1 with the formula =A1, it returns 123, but not formatted in red. What formula can I use to return both the data and the formatting of the referred cell please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
flagging cells that have been referenced | Links and Linking in Excel | |||
Sorting Referenced Cells | Links and Linking in Excel | |||
Indexing Referenced Cells | Excel Discussion (Misc queries) | |||
Question about tab naming and referenced cells | Excel Discussion (Misc queries) | |||
Sorting referenced cells | New Users to Excel |