Referencing a cell for value and format

**maxlee80** · 12-07-2009, 10:53 AM

Hi, I have created a table in Excel 2003 containing values and specific formatting (colours).
I want to have a second worksheet in the same workbook with a cut down version of the same table (fewer columns). However, when I reference the cells, I can only reference the values and not the formatting. I need the formatting to automatically update as well as the value when the master table is changed. I then intend to lock the cut down table, so only the master can be amended.
Any ideas how I can get the formatting to also update?
Thanks
Max

**Palmetto** · 12-07-2009, 11:00 AM

Any ideas how I can get the formatting to also update?

It will require use of VBA. Links to other worksheets only returns the value of the cells and not the formatting. There is no built-in formula/function in Excel to apply the formatting of a source cell to a target cell.