View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Solutions Spreadsheet Solutions is offline
external usenet poster
 
Posts: 33
Default Change Cell Background color when Cell changes

Steve;

Unless you are familiar with writing some VBA macro you don't have many
options.
I could suggest one, but that is with one thing in mind.

Is it so that you could be satisfied with the fact that a cell change is a
change in value, say below zero or something.
If so, you could work with conditional formatting.
Lots of examples about that can be found with google or on the forum.

If not, you have to work with VBA macro's and opt for an application event
called Worksheet_SelectionChange.
Chip Pearson has examples on his website, but this is not easy.

Mark.
--
Rosenkrantz Spreadsheet Solutions
Witkopeend 24
1423 SN
Netherlands
------------------------
E:
W:
www.rosenkrantz.nl
------------------------




"Steve Roberts" wrote in message
...
I have a Department that wants to have a button added to a worksheet that
would 'watch' for any cell changes. If a cell changed, make the background
of that cell a different color. Is there a way to do this?

Thanks

Steve