Problem with conditional formatting

[mahhdy]

Hi Mr Excelians,
I have some conditional formatting in a list object (table). They are almost 6 or 7 conditional expression based formatting.
Each time I am adding or deleting any rows to/from the table, these conditions duplicated and their area changes. I want a way to have a neat and clean conditional formatting.
I am wondering is there any way to reapply these formatting to that range "Table" after any change that made them messy, or any other solution for such a problem? I think it may fix my problem. I read the Microsoft MSDN help, It seems that only three conditions can be set out with VBA.
Any Idea or solution for help?
Thanks

here is a snapshot of my file.

 

[FDibbins]

It seems that only three conditions can be set out with VBA.

if you are using 2007 or later, then you can use much more than 3 rules, that only applied to 2003 and earlier

 

[mahhdy]

if you are using 2007 or later, then you can use much more than 3 rules, that only applied to 2003 and earlier

Wow, Thanks,
So the best way is to reapply these rules after any change in the table?
Is there any list of changes should be considered in this regard?
For sure Sort or filter are OK, I think I should specify just some specific changes in my code. Any Idea or suggestion?
Yours,
M

 

[FDibbins]

If you set the CF range and insert/delete rows within that range, then the CF should not be affected

If you need to add rows at the end, set your CF range to be 1 or 2 rows more than your lowest row, then when you insert a row at the bottom, the range should adjust itself

 

[mahhdy]

If you set the CF range and insert/delete rows within that range, then the CF should not be affected

If you need to add rows at the end, set your CF range to be 1 or 2 rows more than your lowest row, then when you insert a row at the bottom, the range should adjust itself

Unfortunately, My experience doesn't show such point.
As you can see, My CF range is very higher than table range. But even in add cases, the new rows will have their own CF's.