Conditional Format Based on Cell Value - Getting Method Range of object Global failed erro

[ellenlewis]

I am trying to apply conditional formatting to a report. Shading will occur for regions and certain cells pertaining to that region that need to be reviewed. Each region and corresponding cells to review are shaded the same color - a different color for each region.

The code I have below shows a couple of the regions but I am getting a Run-time error - Method Range of object Global failed. I have tried changing the line of code several ways but I haven't had any luck. And as you will see below, there are many lines written exactly the same so while it is stopping near the top, this error really occurs throughout. I realize that I can record this but I am trying to shorten the code and hopefully it would run more efficiently.

I would appreciate any guidance or ways this code could be corrected and/or better written. Also, since I still learning, I would appreciate bits of explanation so I can make notes in the code for future use/guidance.

Please Login or Register  to view this content.

Again, I appreciate any help provided.
Thanks.

[torachan]

You need to give Excel a clue as to what sheet it is working on.
Take care to note where the extra point(full stops) and commas are (they are small but very important.
I have only correct the small piece of code, you will have to correct all the rest.

Please Login or Register  to view this content.

just re-read the code - most are single cells so address them as such - rows 4 & 5 can be amalgamated as a range.

Please Login or Register  to view this content.

[ellenlewis]

Thanks so much! This worked and thanks for explaining. Getting the right code is always nice but explaining it is even better!!
I appreciate your time and help!
Thanks again!

[torachan]

thanks for the feedback and added rep point - glad to have helped.