code to highlight rows and add two columns

[cmccabe]

Can you please modify the code below, especially the IF statement (should be if any value in J2:J is <=120 or Yellow Then D2:D is Red). Also, is the reads code correct? Thank you very much.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[stnkynts]

What does this mean "(H2:H + I2:I <+120)"?

is it also possible to color column D the same as the range (for example if J2 is Yellow D2 is Red and if J3 is orange then D3 is Red)

Yes. Like this

Please Login or Register  to view this content.

[cmccabe]

Sorry that's a typo, should be H2:H + I2:I <=120

Looking to add column H + J and if that sum is less then or equal to 120 then column H and J turn orange.

[watersev]

hi cmccabe, why do you not use conditional formating to do those colouring without VB?

[cmccabe]

It makes it easier with macro in this case then to use conditional formatting.

[stnkynts]

watersev brings up an excellent point. I will answer with what I think you are asking for in macro form.

Please Login or Register  to view this content.

This will check the addition of column H & J and if less than or equal to 120 will highlight column J and D accordingly. The next loop is untouched as I do not believe it was part of your question.