Conditional Formatting changing order when deleting a column

The first thing I would try is make sure the 'stop if true' check boxes are ticked when the rules are in proper order, it should make them lock in order (sort of like a nested if - ' if this, do first, else if second...')

Hope this helps

could you upload a sample showing this effect, iI haven't been able to re-create it ..

see signature for uploading file

Yes, still working on it, may have a work around for you, but it is definitely odd behavior...sorry about not replying earlier, but have been having great difficulty logging in

Not sure why it wants to make that particular rule jump up to the top, but here is the work around I managed to come up with, it works on your sample, and i see no reason why it shouldn't work for your real data (hopefully )
Here is what I managed to make work:
First, remove the rule vi (the one for highlighting odd rows)
Second, insert a new column A, then in A4, enter this formula =IF(ISODD(ROW()),1,0) drag down as far as needed..
Third, select column A, apply filter, uncheck all, then check 1, this will show the odd rows
-Select the rows and columns that you want the fill in
-select Format (NOT Conditional Formatting, just the regular format)-> Fill select fill color, then ok
Fourth, Select the filter drop down in Column A and check All again
Fifth, remove the filters (select filter from the sort and filter ribbon item again, this should remove all the filter drop downs)
Finally, Delete Column A

this should apply your base odd row formatting, the conditional formats will be applied as they come true, and the deletion(or insertion) of columns shouldn't affect them anymore..

Hope this helps

PS- if you need any clarification of the steps, just ask here again - Dred

Edit-
The only thing I can come up with WHY the CF keeps jumping on you is that the first 5 rules only apply when you reach a certain column, before that, it is the FIRST (only?) rule, so maybe when you delete the column, Excel is Trying to "help" you..

Perfect!
I was n't sure I made the steps clear enough, so I'm pleased to hear it worked well for you