For loop - Conditional Formatting

Hi,

Could someone please help me to make a for loop for a Conditional Formatting macro?

Below you see what I'm gona do. But I dont want that to be applied just to G6. I need it in G6-G200 but the "6" in $H6>=$G6 must be change with the row number.
Like G7 would get: Formula1:="=$H7>=$G7"

Please Login or Register  to view this content.

Thanks for the help!

You do not understand.

G7 would get: Formula1:="=$H7>=$G7" automatically if you select your range G6 to G200 and write $H6>=$G6 in G6.

To stop excel doing that. you must use the formula. $H6 >= $G$6 in G$6.

So no loop is required.

Hi,

My understanding is you want apply CF if cell value in column G is greater then equal to value in column H if so you following should work for you:

Please Login or Register  to view this content.

Regards,

Good point. Thanks.

This is doing what I want:

Please Login or Register  to view this content.