The Order of Conditional Formatting Rules is Changed by a VBA Macro

I'm using conditional formatting in Excel 2016.  I'm also using a macro that adds rows, deletes rows, and changes the values of various cells. Executing the macro causes the order of my conditional f...