software

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: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=513830That depends on how you are quot;pulling overquot; the data. If you use formulas in
the destination cells then you cannot quot;pull overquot; the format, just the
value. If you copy and paste, it all goes. You can copy and paste manually
or by VBA. HTH Otto
quot;CBrausaquot; gt; wrote in
message ...
gt;
gt; I have a master, I will make changes to it and highlight the changes,
gt; the information then is pulled over to the additional sheets in the
gt; workbook. Can you make it pull over the color (highlight) along with
gt; the changes so I don't have to go through 20 worksheet trying to find
gt; where the changes are and manually highlight them?
gt;
gt;
gt; --
gt; CBrausa
gt; ------------------------------------------------------------------------
gt; CBrausa's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24677
gt; View this thread: www.excelforum.com/showthread...hreadid=513830
gt;
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