Glad it worked...

To copy to the other rows... you have to be careful because I'm assuming you only want the formatting per row, correct? If so, highlight the first row or range, CTRL-C to copy, then use the Format Painter to the next row... one row at a time! If you choose a bunch of rows, then the conditional formatting will assume the ranges in the conditional formatting will apply to all the cells in all the rows... unless that's what you want...