Change Row color based on cell value

Hi,

I'm trying to change range row color based on cell value.
my code works but instead of changing range row color it changes entire row.
I want To change color just in A:H.

Thank you

here is my code:

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

Try this...

Please Login or Register  to view this content.

tedy, welcome to the forum.

2 things though...
1. do you really need to do this through VBA? regular conditional formatting will do it for you.

2. Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here