c. Count the number of times any truck driver is schedule to ship a load greater than its truck capacity. d. Highlight table rows for given pickup store and route order. e. Calculate the total shipment load to be picked up at each store for each route order. I need help with c - e and the formulas and instructions on how to do the highlights on the table rows. Thank you!

Practice 2 (Lecture 2) a Calculote the total shipment load to be dropped off at each store b Check i the total dropo per store is less than the requested demand, so calculate the demand shortage and display a message # short", otherwise leave blank. cCount the numher of times any truck driver is schedule to ship a load greater than its truck copacity d Highlight table rows for given pickup store and route order. e Calculate the total shipment load to be picked up at each store for each route order ruck Driver ID Route Order Pickup Store Dropoff Store Shipment Load ABC1234 ABC1231 ABC1231 DEF56/8 DEF5678 DEF568 DEF5678 GHI9101 GHI9101 GHI9101 KL1121 KL1121 KL1121 KL1121 MNO3141 MNO3141 MNO3141 Total DropOff DoorMart K-Shop K-Shop Green loor DoorMant GreenFloor Bullseye Store Name DoorMart K-Shop Bullseye GreenFloor Left-Aid Demand Warning Demand met Demand not met Demand met Demand not met Demand not met 585 GreenFloor 86 103 A20 ullseyeK-shop Left-Aid 14 120 15 Left-Aid Left-Aid Truck Driver ID Truck Capacity Capacity Warnin 120 120 120 110 130 130 110 147 ABC1234 DEF5678 GHI9101 KL1121 MNO3141 PQR5161 STU7181 Wx9202 YZA1222 GreenFloor GreenFloor DoorMant Bullseve DoorMart K-Sho Left-Aid GreenFloor Left-Aid DoorMart Bullseve Lett Aid DoorMant GreenFloor DoorMart Highlight table rows for given Pickup Store and Route C GreenFloor K Sho Pickup Store Route Order PQR5161 STU7181 STU7181 STU7181 VWx9707 VWx9707 VWx9707 30 GreenFloor Left Aid 105 DoorMart DoorMart ent to be Picked Up at each store for each route order Route Order reenFlkuor GreenFl Left-Aid 36 el-Aid 131 GreenFloor Left-Aid 38 YZA1222