How to prevent excel from copying conditional formatting rules

I've been charged with the task of creating gauge sheets for oil well production. All it doe is calculate the increase in feet and inches in a tank and converts it barrels based on the dimensions of the tank. Getting the math and calculations to work has been very simple and effective.

What has been making me want to pull my hair out is this superfluous conditional formatting I'm required by my employer to add. It's there to make the sheets easier to read. The first giant headache was a bug in Excel 2007 that jumbled the conditional formatting rules whenever you made a copy of a spreadsheet (I have to make copies for each month's production and every time I copied a sheet over ever little formatting rule I created got its parameters so mixed up that it was basically destroyed).

Thankfully someone on this forum pointed out that it was indeed a bug in Excel 2007, so I updated to 2010.

Now there is another problem I have discovered with the conditional formatting that I believe is much easier (and cheaper) to fix.

If you look at the two spreadsheets I've attached you will see that the one entitled "lees ratcliffe" does not have a bunch of copies of formatting rules in columns B,C,D, and E. This is because I have not used the drag function to copy identical numbers

On the other sheet, entitled "Ezel USA . . ", you will see that I have already entered some tank gauges. Notice the identical gauges in lines B and C. I would just use the drag function to copy that same number. I was unwittingly creating some bizarre copies of the formatting rules which jumbled everything up. Excel copies the formatting rules just like it copies an equation whenever you drag-copy cells.

I could punch the same numbers in over and over to avoid copying formatting rules but that is ridiculous.

All I need to know how to do is disable Excel from copying the conditional formatting rules when I use the drag-copy function. I've looked around through the options and cannot find a solution. I feel that it has to be possible in some way though.

If anyone can help it would be greatly appreciated!