Change cell value and color based on anothers cells values

[luizmachado]

I don't know another way to explain if it isn't based on the attached worksheet (it is not the full file, but only the testing part).


percentage difference column (I4:I16) in worksheet "May" should calcute the percentage difference between total (G) and last month (H).



For example:
When G value (total) < H value (last month) then
I (percentage) = 1 - (G/H) in GREEN scale 'it means that the actual month is I% lower than the last month

When G value (total) > H value (last month) then
I (percentage) = 1 - (H/G) in RED scale 'it means that the actual month is I% higher than the last month

When G value (total) = H value (last month) then
I (percentage) = "0" in GREEN scale 'it means that the actual month had no difference compared to the last month


If I use this logic above with an IF condiction, it'll work, but if I change, for example, J23 value (which will change G5 value), I5 won't change. Only if I insert another data.


Basically, what I want is that if "G" or "H" is changed, "I" changes together.

Thanks,
Luiz.