Hello
thank you very much for the serious macro changes, but I'm afraid you misunderstood me.
Now, the last table I sent and the addition in the columns P , Q , R - was only if you need in the calculation and tests to compare them.
Otherwise, in these 3 columns, these values are not there, they are entered in CF. (Otherwise it's a clever idea)


The other thing you mention about these 0's is a test file very close to the original one and the picture is almost the same as every single month ahead it will change and in every single cell there may be a value (some number).


In the last file you sent me, I decided to try and test by plotting numbers on row 21 and when I hit the macro, nothing like coloring came out on that row.
And the values are increased, to be +100,+200,+300,+400
I don't understand either, why didn't you color them?
I'm wondering why it doesn't color in the full range (after doing a check) C3:N60
2023-03-12_090329.jpg

I'm not that good at writing macros, but I have a feeling that you always take the values that are in/from O4:R4, and maybe I don't understand the macro and it takes its values from each row adjacent to it (so must be).


Could you tell me, I couldn't figure this out:
Call AddCF(4)
Call AddCF(5)
Call AddCF(6)
Call AddCF(7)
Call AddCF(8)
Call AddCF(9)
Call AddCF(17)
what is he doing
I can't figure out where you get that 4,5,6,7,8,9 and 17.
If when the macro is pressed, everything is deleted and then it recalculates and applies the colors where needed.
Thank you very much and I remain available.


And to mention again, the last option is quite clever, because it will save me a lot of writing and changes of ranges of cells, columns, values.
Thanks