Conditional Formatting duplicating rules

Hi!

I recently encountered a very big problem with Conditional Formatting in Excel 2013.

Now, I don't know if this is fixed in later versions of Excel. I can not upgrade my version either, at least not until I receive admin access to my office computer.

So, here's the deal. I have a spreadsheets with a range of entries:

Now, let's apply a rule for Conditional Formatting. Gradient color scale based on value, simple stuff.

As you can see, the range goes all the way to B15. This is only to allow easy demonstration of the problem.

Now, let us see what happens when we copy the entire row of 6, and paste it below our number 9.

Seems all well and good, wouldn't you agree?

But wait a minute, why is it that the pasted number 5 is as yellow as the number 9 above?

Let's take a look at the Conditional Formatting Rules Manager;

Uh-oh! It seems Excel has duplicated our rule, and made the first one exclude the pasted row.

Why is this?

Does it have a solution?

We had a problem with this where our very important backlog file became completely unusable because of the same problem, and with more than 1000 rules for Conditional Formatting, this slows the file down by a lot. Also, to work with the file efficiently, we need to copy the entire rows since we use so many columns.

I know that copying the cell individually does not have the same effect. I am looking for other solutions.