HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED

[Shawn lee]

Hi all,

Any good solutions to change cell color onces its being edited?

For example, I have a monthly report in excel format. In August all the
results are filled in. Then comes September, when I change the numbers
or words, those cells that are different (Edited) from August will have
a cell color changed say maybe yellow or blue. So as to differentiate
from those that are not edited. I know of the function in excel which is
Track Changes. I want something like that, but I want the cell to change
color and not highlighting it only.

So any one have any bright ideas to this? Thanks

*** Sent via Developersdex http://www.developersdex.com ***

 

[Nigel]

Is this why you posted the same question twice but not in a different
color?!

Try using the change event for the cell(s) in question, you will need to
reset the cells to a neutral color first, maybe use a control button, then
as each cell is changed trigger a color change.