Why don't you just select the cell with the formatting, select "manage rules" and then extend the selection of cells that these rules apply to.