Change Row color based on cell value

[tedy]

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

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[FDibbins]

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

[tedy]

Thank you very much
This is exactly what I wanted to do.
Appreciated. Thank you

[tedy]

Sorry for not keeping the rules, this was my first question.
Next time I will do it properly
Thank you one more time