Color rows according to a specific column and a specific cell

[k0st4din]

Hello again, I agree with you and your suggestions and since I don't understand it at all, that's why I'm saying what I want to happen as a result. The idea is that apparently there is something in my table that prevents the macro from working as it does in a test environment. I gladly accept any of your suggestions, because you are God to me. I'll test and write again in a moment. Thank you very much Paul!

P.S Hi Paul, I just downloaded version 10,I'm uploading a video because I'm starting to feel like I'm an oligophrenic. It doesn't want to color the cells for me.
I removed all the already colored cells by the number and pressed the button to see if it would color them again but nothing happens.

link to video - >
https://youtu.be/K6Y13pEiAM0?si=RCBlLx7OSWXapgxs