I am trying to copy the conditional format from one cell that effects an entire row. Right now I have Row 2 conditioned to turn green if column D is X, Yellow for P and Red for R. I want to copy this same conditional formatting for each row below. ALSO not disrupting the formatting now on cell type and borders as that is all different.