code

[cmccabe]

I am using the modified code below (thanks for your help John Hugo).

In "For Each rngCell In Range("H2:I" & i)" section how do I make it (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)

Please Login or Register  to view this content.

Thanks.

[Pete_UK]

I doubt if you will get any responses with a title like that. Check out the Forum Rules on thread titles, and change it to something that describes your problem.

Pete

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.