I have some data on a worksheet grouped by subtotal in two columns with conditional formatting in those two columns. The conditional formatting highlights a cell if it exceeds a certain number. The conditional formatting may highlight a quantity in the data row, the subtotal row, or both. I have VBA code that does all this.

What I need is code that will either identify the subtotal grouping that contains conditional formatting or does not contain conditional formatting. Ultimately I want to keep the entire subtotal grouping associated with the conditional formatted cell (not just the row the conditional formatting is on) and discard the rest. Does anyone know how to do this? Thanks for any suggestions.