Change the color of a cell if its own value changes certain percentage

[Ralphmex]

Hello, i´d like to know if there could be a macro to change the color of a specific cell if its OWN value changes certain percentage??
When one makes the change, it will need to instantly record the previous value and then if the new value is for example a 20% increase, then the macro will change the color of the cell.

Then another macro would be neccesary to reset the cell colors back to normal for the sheet to be ready for new value monitoring.


I hope it was clear,

Thanks!
Ralphmex.

[p24leclerc]

How long will you see the new color in the cell? I think it will blink so fast, you'll never notice it changed.

[Ralphmex]

Thanks, for answering,

For example:

- There is value of 10 in A1.
- I run the macro and it will stay running.
- Then if i (or a formula) changes the value of A1 to say 13, the macro will detect that there is a change in the value and also it will detect that it is greater than 20% of the original number, so it will color the cell to red, and will maintain the color in red.

If the change was not greater than 20%, it will not modify the cell color.

Did i explain myself ?

Thanks,

[p24leclerc]

Here is a macro I did some times ago. I did some modification to suit your needs. Hope it does what you want. This macro will keep track of all changes made to cell A2 in Sheet1. Tracking record is in Sheet3. There is a button in Sheet1 to reset color of cell A2.

[Ralphmex]

THanks a lot dude! i´ll give it a try!