Column H change color and change prices

[Romano_odK]

Good afternoon,

In my case I got a column H which is a part of a table and are prices. The data starts at row 7 until the end of the table. What I like to accomplish is that when I put a number, which is a percentage in H5, the whole column H will increase with that percentage and change to the color red.
That is the first change, because if I would then overwrite a price in that same column by hand it should be mandatory over the percentage change and also change to green.

For me this look like its impossible to do, but is it?

Thank you for your time and efforts,

Kind regards,

Romano

 

[Tivakaran]

Hi.
What I understand is that H7 already hv value which you want to increase as per H5 percentage,right? If yes, then you could add "+$H$5" (without quotes) at the end of end of the formula in H7 and copy it all way down. This will add % to H7 (given that H7 is percentage as well)... then you could use conditional formatting to set colours I guess