Hi, I am struggling with excel macros.
I am trying to make macros that can automatically change color of cell following instructions. i.e
Suppose there are two rows 'A' & 'B' and their cell contain respective value of '13' & '10'. 'A' row value will always remain static, however only 'B' row values will be changed by the days pass. So if i change the value of B to 5 so their is change of -8 compare to A's value. now the color of both the cells (Row 'A') needs to change Blue.
Like the same way if i change the value of B to 3 then the difference is -10 compare to A's value then the color needs to change Green. if the value in A & B is same then it needs to be Yellow color in both the cells.
So i am looking for help in macros or formula that can help me make this. Basically its all depend on A & B's Value & the conditions that we are going to use.
I shall be very thankful if any can help me in this.
I am trying to make macros that can automatically change color of cell following instructions. i.e
Suppose there are two rows 'A' & 'B' and their cell contain respective value of '13' & '10'. 'A' row value will always remain static, however only 'B' row values will be changed by the days pass. So if i change the value of B to 5 so their is change of -8 compare to A's value. now the color of both the cells (Row 'A') needs to change Blue.
Like the same way if i change the value of B to 3 then the difference is -10 compare to A's value then the color needs to change Green. if the value in A & B is same then it needs to be Yellow color in both the cells.
So i am looking for help in macros or formula that can help me make this. Basically its all depend on A & B's Value & the conditions that we are going to use.
I shall be very thankful if any can help me in this.