compare cells for each row

[christopherL]

Hiho,
I want to create a script that compares the following for each row.

I have values in column G and H.

If the value in G > value(H)/2
then mark cell G with a color..

I am quite new at VBA and dont really know how to set this up

Regards!

/ C

[Fotis1991]

Perhaps something like this?

Please Login or Register  to view this content.

[christopherL]

Hey this worked, however once it changes color I can't change it back? :P
It's like this script locks the background color to green? :P

Perhaps something like this?

Please Login or Register  to view this content.

[Fotis1991]

Apologize. I missed your reply.

..Hey this worked, however once it changes color I can't change it back?

What you mean saying "to change back"? When you run the macro once then in any row that the condition is correct, is highlighted.

[christopherL]

I have another macro that should replace the color, but it can't cause it seems like the color is locked into the cell or something :P

However, thank you very much, I have something to work from here

Apologize. I missed your reply.



What you mean saying "to change back"? When you run the macro once then in any row that the condition is correct, is highlighted.

[Fotis1991]

This one can un-color the range..

Please Login or Register  to view this content.

So...

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.