Excel Worksheet Change Event
 

How do I create a micro in Excel to turn all cells in a workbook to a a
different color when any changes have been made to each? So, I need a
formula such that any change to a cell makes the color of the cell
change to a designated color. Please be detailed, I am new at Excel.
Thank you!

Excel Worksheet Change Event
 

Hi,

the color of the cell depends on the value of the cell or on the event
of change of value?

If the color depends on the value, use conditional formatting.

If the color depends on the change of the value, use Worksheet_Change
event.

Let me know and I will give you more details...

Regards,
Ivan

Excel Worksheet Change Event
 

Ivan,

Thank you so much for responding so quickly.

The color depends on the change of the value, 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.

Are you able to explain excatly how I would make a "Worksheet_Change
event" to make this happen on my spreadsheet?

Thank you again.

Excel Worksheet Change Event
 

Ivan,

Thank you so much for responding so quickly.

The color depends on the change of the value, 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.

Are you able to explain excatly how I would make a "Worksheet_Change
event" to make this happen on my spreadsheet?

Thank you again.

Excel Worksheet Change Event
 

Hi,

sorry for responding that late, I had to leave the office earlier
yesterday.

Paste following code into worksheet code module (if you want to see
changes in worksheet MySheet, then paste it into this module):

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 6
End Sub

You may change the colorindex (now the value is 6), if yellow is not
your favourite color.

Regards,
Ivan