Hello, I just tried the table but it's not like that. That's why I'm uploading another table in which I've shown (figuratively speaking, real numbers) how things and colors should happen.
This test checks absolutely the entire range, and I said at the beginning that the check should start from the cells that I colored in brown (at least for me it's brown).
The other thing is that in the macro, I don't see anywhere (and this is most likely because it's not working correctly) where I personally can write exactly from which cell to the right it should start calculating.
In the table that I'm going to upload, please take a look (because I didn't do it for all rows), but these: S5 - and to the right after that, Q6- and to the right after that, M8 - and to the right after that, T9- and to the right after that, P10- and to the right after that, A34 - and to the right after that.
I made them colored up to a maximum of 4 colors so as not to make them all 10 colors, but the logic is clear.
The question is, somewhere in the macro, I can write down exactly which cell in the row to start calculating and coloring, and not have everyone start from column A. This first
Secondly, there is no need for the cell from which the comparison is made to be colored in a certain color
You say it takes it from the brown cell to the right, but in your macro it doesn't do it correctly.
For example: It should start from N12 - to the right, and it colors the entire row from A12, where it meets the requirement and reaches the specific numbers, for N16- it's also not true, again it colors the entire row. From C16 to the right.
"What are the colors in P1:Y1 for?" The colors are just for my help and convenience, they don't do any other work. Kind of like Notes (hint, reminder)
Maybe I'm confusing you something. This brown cell is just for reference, from where exactly on a specific row the calculation and coloring should start. This is missing in the macro and I won't be able to say where to start checking. The idea is not to capture the entire range and check everywhere. I need to be able to record in the macro from where, to where.