Conditional Formatting Issues when adding new rows

Hello, I have written quite a few rules for a large database of information that changes the colour of the row depending on various conditions. This is all working perfectly right now, BUT... when a new row is inserted, I need all of the conditional formatting (and formulae in certain columns) to apply to the new row too. At the moment, when I insert a new row, it changes the colour of SOME of the existing rows. So, when I insert a new row underneath row 17, the colour of row 21 changes from purple to red when it should stay as it was. Is this an issue with my conditional formatting or with the formulae in the cells?

And example of a conditional format is as follows:

Rule: =AND($AH14>0,$AG14>0,$AI14<>0)
Format: Changes row to red
Applies to: =A14:AI3000


Please can anyone spot my error? The document is huge and contains 12 worksheets which all interact with each other. This is why I haven't uploaded it yet. I can't really split it but could upload the whole thing if the information above isn't enough.

Thank you in advance...

What is the CF to change a row to purple?
The best way for us to diagnose something like this is with an example worksheet. Can you upload a workbook without confidential info in it? (Go Advanced>Manage Attachments). Even if it's just that one sheet with the CF in it.

Everything is purple in your example because of the number of errors that are showing up (#REF).
The defined name VOL is giving #REF so that screws up many of your VLOOKUPS.
Is that because you stripped this down?

Looking at your conditional formatting, it looks reasonable although not consistent. I would start there and fix the ranges so they are consistent, i.e = $A$14:$AI$10455.
You have two red rules, delete one
The rules themselves are unique and one shouldn't interfere with another.
Since I can't duplicate your error (everything is purple), that's about all I can tell you.

Do you use any INDIRECT functions in the spreadsheet? Maybe you can convert some of the formulas to constants (Paste values) before you delete whatever they are referencing. For example Columns N, S and T and then upload it again.

You could also Zip the file and upload it if that makes it manageable.

The formula in AH is the problem.

=INDEX('Mar 2016'!$A$13:$W$1289,,17) will return the value on the same row from Col Q of Mar 2016. So row 20 is 0, then you insert a row, and row 21 is 129.99 (130). So it is not doing what you want it to do. What do you want Column AH to be doing?

VLOOKUPS don't need to always begin with Col A. Looks like the machine number is in Col J of Mar 2016 also so we'll have the range be 'Mar 2016'!$J$14:$N$1171

So in AH14 of Jun 2016, copied down

=VLOOKUP(J14, 'Mar 2016'!$J$14:$N$1171, 5, FALSE)
That should stabilize your workbook a bit.