Excel 2007 : Copying Conditional Format Rules

When I try to copy and Paste a conditional formatting rule to other cells in the same column, the row number only advances for the first cell then remains the same thereafter. Furthermore, the paste adds to the existing rules in the cells rather than simply replacing them. I can deal with the latter by clearing the cells first then pasting. But, the fist problem is driving me nuts!