Hello, long time lurker, first time poster. I don't know where I'd be without this forum. Ok, now that the butter has been served..

I have a sheet that resembles this... repeating for about 1800 customers. What I would like to do is delete the entire customer section if the last three columns contain nothing but zeroes, for all rows.. I understand that is most likely a pipe dream. I have already used conditional formatting to mark all cells with a value of zero in the last three columns, so even if all I can do is delete the row in which all three columns (D, E, F), for that row alone (no need to trouble yourself with multiple rows ) contain conditional formatting, you would be my hero!


Cust1 | | | | |
------------------------------------------------------------------------------
Cust1 | Qty | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust1 | Dollars | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust1 | Cost | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust1 | GPA | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
-------------------------------------------------------------------------------
Cust1 | GPP | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
-------------------------------------------------------------------------------
Cust2 | | | | |
------------------------------------------------------------------------------
Cust2 | Qty | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust2 | Dollars | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust2 | Cost | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust2 | GPA | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
-------------------------------------------------------------------------------
Cust2 | GPP | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
-------------------------------------------------------------------------------
Cust3 | | | | |
------------------------------------------------------------------------------
Cust3 | Qty | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust3 | Dollars | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust3 | Cost | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
------------------------------------------------------------------------------
Cust3 | GPA | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
-------------------------------------------------------------------------------
Cust3 | GPP | (Blank or Letter) | 0 (or number) | 0 (or number) | 0 (or number)
-------------------------------------------------------------------------------