In Excel 2003, how do I show the same format of text of a referenced cell from another workbook?
I basically have two workbooks
- The Master Version where I do my work and format the cells with bolds and coloured text to reflect the input from various contributers
- The dumbed down version for the masses to ponder over, without providing them the opportunity of screwing up the Master version.
The dumb version basically references cells directly in the Master, but sadly the formatting and colours of the text which are present in the Master are not brought across to the dumb version, which detracts considerably from being able to read the text in the dumb version.
Is there any way I can force Excel to not only reference the text in the cell, but also bring along the formatting of the text within that cell i.e. the same as if I had performed a copy and paste of the entire cell?
The formula as it stands as present in the dumb verion is akin to:
but i suspect thie only brings across the text of the cell. not the formatting within that cell.