For Each Loop code issue

[mannalora]

I know this code is very rough, I am very rusty, the 90s seem so recent. I cannot get the macro below to execute properly. It should go through each cell in a defined range read the value and change the cell background to correspond. The If Then nest works properly for each active cell, but cannot get it to loop through the range. Thank you in advance

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Kaper]

Try:

Please Login or Register  to view this content.

[mannalora]

Thank you, I will begin using code tags. I do and will continue to search Google for applicable examples and sample code.

[alansidman]

Try this:

Please Login or Register  to view this content.

[mannalora]

Awesome, Thank you worked perfectly. It looks like the issue was defining Cell? I will add to your reputation

[mannalora]

Thank you, got it I will change status to closed