Results 1 to 20 of 42

Thread: Color rows according to a specific column and a specific cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    VBAX Tutor
    Joined
    Sep 2012
    Location
    London
    Posts
    285
    Location
    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.
    Attached Files Attached Files
    Last edited by k0st4din; 07-02-2025 at 02:06 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •