How do I make a "Worksheet_Change event" to show any changes to cells?
 

How do I make all the cells on a worksheet change color when a change
has been made to any of the cells?

ie. "use Worksheet_Change event" then. If any change at all is made to
a cell I need o see the cell colored to identify a change has been
made.


Can someone explain exactly how I would make a "Worksheet_Change
event" to make this happen on my spreadsheet?

How do I make a "Worksheet_Change event" to show any changes to cells?
 

Well, this is a rather ridiculous (but quick) solution. You could make
a copy of the current sheet (hold ctrl and drag your sheet) and set all
cells in the original worksheet to conditional format as red if they
are not equal to the copied sheet.

Just a thought.

How do I make a "Worksheet_Change event" to show any changes to cells?
 

Try

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 3 'change ColorIndex to desired
color
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

wrote in message
oups.com...
How do I make all the cells on a worksheet change color when a
change
has been made to any of the cells?

ie. "use Worksheet_Change event" then. If any change at all is
made to
a cell I need o see the cell colored to identify a change has
been
made.


Can someone explain exactly how I would make a
"Worksheet_Change
event" to make this happen on my spreadsheet?