Excel 2007 : Copying Conditional Formatting into Multiple Ranges

Good Afternoon,

I am working with a pivot table containing bill invoice data. In the pivot table, each row represents a different line item on the invoice with columns organized by month. I have added 4 rules with conditional formatting to a few rows to highlight any month that is outside of 2 or 3 standard deviations of the mean. My goal is to have these rules set up on all the rows. If I select the entire table, all the data will be used in calculating a standard deviation, so I have to add the rules by row. Unfortunately, I have not been able to figure out how to copy from row to row to save myself time setting up 4 rules over and over.

Any suggestions would greatly be appreciated!

Thanks!