I have a master, I will make changes to it and highlight the changes,
the information then is pulled over to the additional sheets in the
workbook. Can you make it pull over the color (highlight) along with
the changes so I don't have to go through 20 worksheet trying to find
where the changes are and manually highlight them?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513830

That depends on how you are "pulling over" the data. If you use formulas in
the destination cells then you cannot "pull over" the format, just the
value. If you copy and paste, it all goes. You can copy and paste manually
or by VBA. HTH Otto
"CBrausa" wrote in
message ...

I have a master, I will make changes to it and highlight the changes,
the information then is pulled over to the additional sheets in the
workbook. Can you make it pull over the color (highlight) along with
the changes so I don't have to go through 20 worksheet trying to find
where the changes are and manually highlight them?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile:
http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513830

I believe this is what you want:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
Target.Interior.ColorIndex = 3
For Each c In Target.Dependents
c.Interior.ColorIndex = 3
Next c
End Sub

This is an event procedure, it fires whenever there is a change in a
cell manually. It examines which cells are dependent on the cell just
changed and highlights them as well.

To install and test:
In the sheet where you do your data changes, right-click on the sheet
tab and choose View Code.
In the VBA IDE paste the above code.

Is this what you need?

Kostis Vezerides