Change Format of Linked Cells

[Girth]

Can anyone help?

I have data in several source workbooks which is linked to another single summarising destination workbook. When I change the value in a cell in the source workbook from a projected value to an actual value I am currently identifying this by changing the fill colour, i.e.from projected value = blue to actual value = no fill, and then have to do the same in the summarising workbook, but with literally thousands of entries this is becoming time consuming.

Is there any way that when I format the cells in the source workbook that this change also happens in the destination workbook, I have tried if statements and conditional formatting but keep coming up short.

 

[Damon Ostrander]

Hi Girth,

I don't know of a very easy way to do this, but it should be possible to write a macro in the summarising workbook that loops through all the linked cells, follows the links back to their source to get the cell formatting information, and uses this to format the linked cells. I don't have time to write this code for you, but perhaps someone else can step in at this point.

Damon

 

[Girth]

OK Damon, will pursue your line of thinking, thanks for your reply.