So, I posted a few days ago, but had an invalid explanation of what I was looking for. Apologies to the community. Here is a what I was looking for.
I have these group of cells: (See Below). My problem is, if for example, I input, on another cell, pickup weight forecasted at 52,000, and Delivery weight forecasted at 7,000, then I should have up to either 64,000 lbs on PU to play with, or...up to 28,000 lbs on DEL to play with. If the cap is reached, on either side, I need a warning, I was thinking conditional format, to tell me that I have reached my capacity (TOTAL). I tried using conditional format for the TOTAL weight, however, 102,000 on Pickups is way different than 102,000 on deliveries. My guys would die on a 119,000 pickup, but not 119,000 delivery.
<colgroup><col span="3"></colgroup><tbody>
</tbody>
I have these group of cells: (See Below). My problem is, if for example, I input, on another cell, pickup weight forecasted at 52,000, and Delivery weight forecasted at 7,000, then I should have up to either 64,000 lbs on PU to play with, or...up to 28,000 lbs on DEL to play with. If the cap is reached, on either side, I need a warning, I was thinking conditional format, to tell me that I have reached my capacity (TOTAL). I tried using conditional format for the TOTAL weight, however, 102,000 on Pickups is way different than 102,000 on deliveries. My guys would die on a 119,000 pickup, but not 119,000 delivery.
PU | DEL | TOTAL |
68,000 | 0 | 68,000 |
64,000 | 7,000 | 71,000 |
60,000 | 14,000 | 74,000 |
56,000 | 21,000 | 77,000 |
52,000 | 28,000 | 80,000 |
48,000 | 35,000 | 83,000 |
44,000 | 42,000 | 86,000 |
40,000 | 49,000 | 89,000 |
36,000 | 56,000 | 92,000 |
32,000 | 63,000 | 95,000 |
28,000 | 70,000 | 98,000 |
24,000 | 77,000 | 101,000 |
20,000 | 84,000 | 104,000 |
16,000 | 91,000 | 107,000 |
12,000 | 98,000 | 110,000 |
8,000 | 105,000 | 113,000 |
4,000 | 112,000 | 116,000 |
0 | 119,000 | 119,000 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>