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 ***

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.

--

Regards,
Nigel
(E-Mail Removed)



"Shawn lee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> 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 ***