linking cell formats to other worksheets

[Karl]

I have a workbook that is composed of 7 worksheets.

The First worksheet is the "Master Document". It contains
informaton on several departments. The other work sheets
contain information on specific departments located on the
first worksheet. I have linked the data on each of the
work sheets to the Master Document so I only have to place
the updated data on the Master Document (1st worksheet)and
it is displayed on the corresponding worksheet.

In addtion to numerical data the cell patterns (back
gound) changes color depending on the value in the cell.
Red, Yellow or Green

I have sucessfully linked the numerical data.

How can I link the cell pattern in the worksheets to
change as the master document is updated?

Karl

 

[Dave Peterson]

Dave,

Thanks,

I will give it a try.

Karl

-----Original Message-----
Did you use Format|conditional formatting on the original cell?

If yes, you could use the same conditional formatting on that receiving cell.

But there is no worksheet formula that will retreive the formatting and apply it
to the cell.

But a subroutine could do it. Maybe you could use some kind of event
(worksheet_calculate??) that would apply the same formatting.


--

Dave Peterson
(e-mail address removed)
.