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...
Bookmarks