January 10, 2020
I have some data on a worksheet with conditional formatting in two columns. The formatting highlights a cell if it exceeds a certain number. I then subtotal the rows (sum) based on quantities in those two columns. 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.