Color rows according to a specific column and a specific cell

[Paul_Hossler]

Now I'm confused -- in ver 013 I changed to the array you asked for in post #36. Every thing else should be the same

All you need to do is manually maintain the array

    aryWorksheets = Array("Blagoevgrad total", "Burgas total", "Varna total", _
        "Veliko Tyrnovo total", "Vidin total", "Vraca total", "Gabrovo total", _
        "Dobrich total", "Kyrdjali total", "Kustendil total", "Lovech total", _
        "Montana total", "Pazardjik total", "Pernik total", "Pleven total", "Plovdiv total", _
        "Razgrad total", "Ruse total", "Silistra total", "Sliven total", "Smolqn total", _
        "Sofia total", "Sofia oblast total", "Stara Zagora total", "Tyrgovishte total", _
        "Haskovo total", "Shumen total", "Qmbol total")
        
    For iWS = LBound(aryWorksheets) To UBound(aryWorksheets)
        Call DoAllRows(Worksheets(aryWorksheets(iWS)))
    Next

[k0st4din]

Hi Paul, I think we've been diverging in writing since yesterday.
I tried to log in to the site several times and it kept giving me some errors that it couldn't log in.
I wrote, wrote and when I pressed the send button several times it threw me out with the described problem.
And apparently while I was writing, you had already sent it (somehow), and I hadn't seen it and there was total confusion.
I'm downloading the file now and I'll see it.
I hope I can send now - what I wrote.
Greetings and I'll reply back.

[k0st4din]

Hi Paul,
I finally managed to access the site. I don't know what the reason is, maybe there was some problem with it.
Now that I'm inside, I immediately reply that with the latest version everything is fine and works great.
Thank you with all my heart for this help from your side.
I'm marking the topic as solved.
I wish you endless health and be always so dedicated and helpful to us ignorant people who can't cope with a given task.
See you soon Paul

[Paul_Hossler]

Yea, the forum has been having some problems lately

Glad you got what you needed