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)
Thanks.Please Login or Register to view this content.
Bookmarks