Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do you get the cell formatting (color) to transfer to a linked cell?
Example: I have added color (red) to a particular cell (A1) in Sheet1. I have linked cell (B2) in Sheet 2 to the red colored cell (A1) in Sheet1 (i.e. =+Sheet1!A1). The cell value (A1) on Sheet1 transfers to the cell (B2) in Sheet2, however the color (red) does not transfer to cell (B2) in Sheet2. I want the cell value and the color (red) to transfer from cell (A1) Sheet1 to the cell (B2) in Sheet2. Is there a way to get the cell formatting/color to transfer along with the cell values from one linked cell to another? Thanks for any help. Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to insert a value in one cell into many cells | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel | |||
Trying to add conditional formatting to every other cell...GOING . | Excel Worksheet Functions | |||
Cells losing formatting | Excel Discussion (Misc queries) |