VBA to Keep Subtotal Groupings Based on Conditional Formatting

[LtCmdrData]

Hello All,

I have some data subtotaled by various quantities (columns N & O subtotaled by column B) . The number of subtotaled rows varies. Sometimes it may be only row, other instances it may be 4-5 rows subtotaled. I have applied conditional formatting in a couple of columns (N, O, & S) to highlight when quantities exceed certain limits or changes have occurred. It might highlight a quantity in a data row, a subtotal amount, or both. All of this I have VBA code for.

Here is where I need help please. At this point I want to remove all the rows of data that do not have conditional formatting but I want to keep all rows associated with a subtotal grouping even if that row does not contain conditional formatting. I don't know how to code to keep the groupings. All the columns have data, I have just removed the data in most columns to keep things generic. Below I have my conditional formatted data bold and in yellow. I apologize for the crude example but hope it conveys the idea. Can someone offer suggestions and/or solutions? Thank you.

A B C D E F G H I J K L M N O P Q R S

Booking Number

Load Number

Customer Charge

Origin Name

Origin City

Origin State

Origin Zip

Target Ship (Early)

Dest Name

Dest City

Dest State

Dest Zip

Target Delivery (Early)

Pallet

Weight

Cube

Type

Lookup

Diff

247613

L569410

05/25/2021 00:00

05/27/2021 00:00

13​

17,122​

17121.5​

0​

247614

L569410

05/25/2021 00:00

05/27/2021 00:00

16​

19,672​

19671.5​

0​

L569410 Total

29​

36,793​

246903

L569396

05/24/2021 00:00

05/25/2021 00:00

2​

1,824​

1823.7​

0​

246953

L569396

05/24/2021 00:00

05/25/2021 00:00

4​

3,958​

3958​

0​

247276

L569396

05/24/2021 00:00

05/25/2021 00:00

4​

7,236​

7236​

0​

247277

L569396

05/24/2021 00:00

05/25/2021 00:00

3​

4,159​

4732​

-573​

247278

L569396

05/24/2021 00:00

05/25/2021 00:00

2​

1,927​

1926.8​

0​

L569396 Total

15​

19,104​

246975

L569395

05/25/2021 00:00

05/25/2021 00:00

17​

27,951​

27951​

0​

247279

L569395

05/25/2021 00:00

05/25/2021 00:00

9​

13,394​

13393.6​

0​

L569395 Total

26​

41,345​

247072

L569394

05/25/2021 00:00

05/26/2021 00:00

13​

20,320​

20320.1​

0​

247073

L569394

05/25/2021 00:00

05/26/2021 00:00

16​

22,927​

22926.6​

0​

L569394 Total

29​

43,247​

247271

L569393

05/24/2021 00:00

05/25/2021 00:00

28​

15,941​

15941.4​

0​

L569393 Total

28​

15,941​

247377

L569392

05/26/2021 00:00

05/27/2021 00:00

29​

18,167​

18166.8​

0​

247379

L569392

05/26/2021 00:00

05/27/2021 00:00

2​

2,431​

2431.4​

0​

247435

L569392

05/26/2021 00:00

05/27/2021 00:00

1​

175​

175​

0​

L569392 Total

32​

20,773​

247434

L569391

05/27/2021 00:00

05/28/2021 00:00

28​

17,869​

17869.4​

0​

L569391 Total

28​

17,869​

246425

L569390

05/25/2021 00:00

05/26/2021 00:00

10​

10,488​

10487.6​

0​

247272

L569390

05/25/2021 00:00

05/26/2021 00:00

16​

21,416​

21415.8​

0​

L569390 Total

26​

31,903​

247104

L569383

05/25/2021 00:00

05/27/2021 00:00

1​

885​

885​

0​

247221

L569383

05/25/2021 00:00

05/27/2021 00:00

9​

16,861​

16861​

0​

247230

L569383

05/25/2021 00:00

05/27/2021 00:00

18​

28,228​

24330.3​

3898​

L569383 Total

28​

45,974​

247400

L569382

05/25/2021 00:00

05/27/2021 00:00

15​

19,983​

19670​

312.5​

247418

L569382

05/25/2021 00:00

05/26/2021 00:00

10​

12,345​

12345​

0​

247520

L569382

05/25/2021 00:00

05/27/2021 00:00

2​

1,954​

1954.2​

0​

L569382 Total

27​

34,282​

246572

L569380

05/26/2021 00:00

05/27/2021 00:00

8​

7,832​

7831.5​

0​

247124

L569380

05/26/2021 00:00

05/27/2021 00:00

2​

2,027​

2026.8​

0​

247580

L569380

05/26/2021 00:00

05/27/2021 00:00

20​

23,710​

23710​

0​

L569380 Total

30​

33,568​