Cell Value from another sheet with Parent cell formatting

[Vijayonline2008]

I have data in first sheet A1 and the value is bold and red color. Now the same value i can get from any other sheet by putting =Sheet1!A1. But how can i retain the format of the cell A1 parent cell in the second sheet ( bold and text as red color ).

 

[Luke M]

In short, you can't. Cell formatting can not be referenced. The best you can do is either copy the formatting from one cell, or do an elaborate macro to detect which cell is being referenced, find that cell, detect the formatting, and change the original cells formatting to match.


If you just need a visual link, you might try using the camera tool (copy, paste special, picture link). Then you would see the cell value and formatting exactly as it appears in the other sheet.