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

%3CLINGO-SUB%20id%3D%22lingo-sub-2326147%22%20slang%3D%22en-US%22%3EThe%20Order%20of%20Conditional%20Formatting%20Rules%20is%20Changed%20by%20a%20VBA%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326147%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20conditional%20formatting%20in%20Excel%202016.%26nbsp%3B%20I'm%20also%20using%20a%20macro%20that%20adds%20rows%2C%20deletes%20rows%2C%20and%20changes%20the%20values%20of%20various%20cells.%20Executing%20the%20macro%20causes%20the%20order%20of%20my%20conditional%20formatting%20rules%20to%20change.%20Why%20is%20this%20and%20can%20the%20reordering%20be%20suppressed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2326147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 formatting rules to change. Why is this and can the reordering be suppressed?

0 Replies