software

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

ie. quot;use Worksheet_Change eventquot; 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 quot;Worksheet_Change
eventquot; to make this happen on my spreadsheet?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.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

gt; wrote in message oups.com...
gt; How do I make all the cells on a worksheet change color when a
gt; change
gt; has been made to any of the cells?
gt;
gt; ie. quot;use Worksheet_Change eventquot; then. If any change at all is
gt; made to
gt; a cell I need o see the cell colored to identify a change has
gt; been
gt; made.
gt;
gt;
gt; Can someone explain exactly how I would make a
gt; quot;Worksheet_Change
gt; eventquot; to make this happen on my spreadsheet?
gt;