The same format on different worksheets 4

[Boomerang]

I have 2 worksheets named "first" and "second"

Worksheet "first" has only text.
Worksheet "second" has formula's to copy the text from "first" like:

='first'!A4
='first'!K13

I change the text in "A4" on "first" then the text in "second-A4" change like the way I want.

But if I change the backgroundcolor[color] in "A4" on "first" then the backgroundcolor in "second-A4" don't change.

Is it possible that the format's on worksheet "second" change if I change the formats on worksheet "first" ???

Please help,
Erik
<-- My sport: Boomerang throwing !!
!! Many Happy Returns !! -->

 

[Boomerang]

Hi Zathras,

I was allready gone when you posted your solution.
It's great to wake up and find an answer, especially when it's what you want.

My sheet is a sort of action-list. I allways begin with copying the new lines on the Master-sheet. Then I copy the same new lines with the formula's on the Slave-sheet (I don't need to automate that) and after that I will add the new text and different background colors on the Master-sheet depending of the status of the action. (The colors can be changed after a while) The Slave-sheet is a print-version because I left out some columns who are not available for the readers of the print. (These columns are hidden on the Slave)

So it looks like your solution is perfect for me now.
Thanx again !!!

Erik <-- My sport: Boomerang throwing !!
!! Many Happy Returns !! -->

 

[xlbo]

Dammit - I was hoping my post hadn't got thru (tried to cancel it). Remembered just after I submitted that formatting changes don't invoke the change event. Is there any way to cancel stars 'cos I'm really quite embarrassed about getting one for that...???? Rgds
Geoff
&quot;Some cause happiness wherever they go; others whenever they go.&quot;
-Oscar Wilde

 

[Boomerang]

Don't worry, as I said, the star is for your immediately answer, trying to help me.

Just enjoy it if someone really compliments you!

Erik <-- My sport: Boomerang throwing !!
!! Many Happy Returns !! -->