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

S

susiecmore

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?
 
T

theseandavis

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.
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How so I make a "Worksheet_Change Event" to show cell changes in Excel? 1
Worksheet_Change 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Cell change event causing EXCEL to crash 3
How to Color a Cell Based on a Range of Cells with Colors 1
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) 14
Worksheet Change Recognize 0
How do you have the cells highlight changes? (no track changes) 1

Top