Hi Rylo,

It worked perfectly, thank you. However, is there anyway to make that formatting copy for column E, F, G, H, I? it only copys to the cells we copy over. Or, is there a way to make E, F, G, H, I just copy the color from column D?

Thanks again for all your help. I really appreciate it. Have a good evening.