link sheets showing exact colour of text and background

[summer2010]

Morning everyone

I've linked two sheets capturing the information I'm wanting, but I also want the linked sheet to show the exact colour of the text and background colour of the cell. Is this possible?

In sheet 1, I have the table with contents and have higlighted the cell background red, in B2, B4 and D3.

On the linked sheet tab again with a table of contents, but I'm only capturing the dates from sheet 1.

I would like the linked sheet to also show the red highlighted cells from sheet 1 as red higlighted cells in the linked cell, if the background or text colour has changed ( i've highlighted peach to show you what I mean )

[Blake 7]

Hi - this should answer your question

http://excel.tips.net/T002769_Automa...ormatting.html


One of the foundational features of Excel is to allow one cell to be equal to another cell. For instance, you could use the most simple of formulas in a cell:
=C7
This copies the contents from cell C7 to the current cell, and updates whenever the contents of cell C7 change. What if you are not just interested in copying cell values, but also want to copy formatting from one cell to another?
Unfortunately, there is no intrinsic way to do this in Excel. There are two workarounds you can try, however. First, you can create a macro that will find out whenever cell C7 changes, and if it does, the macro copies the contents of the cell (including formatting) to the target cell. For instance, the following macro will run every time there are changes in the worksheet. When the change is in cell C7, then the contents of C7 are copied to cell E3 on Sheet1.

Please Login or Register  to view this content.

There are some downsides to this approach. First, it can be slow, particularly if you have quite a few cells that you want to copy in this manner. In addition, the macro only runs if the contents of cell C7 are actually changed, not if the formatting alone of C7 is changed. (There is no way to trigger an automatic event whenever formatting is changed.)

[summer2010]

Thanks Blake 7

I didn't think the formatting could be done when linking sheets, such a shame though. I'll have a play about with your macro to see if it can help. The information will only be entered once, then the formatting used once the event has happened.