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.
[TABLE="width: 276"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]PU[/TD]
[TD]DEL[/TD]
[TD]TOTAL[/TD]
[/TR]
[TR]
[TD="align: right"]68,000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]68,000[/TD]
[/TR]
[TR]
[TD="align: right"]64,000[/TD]
[TD="align: right"]7,000[/TD]
[TD="align: right"]71,000[/TD]
[/TR]
[TR]
[TD="align: right"]60,000[/TD]
[TD="align: right"]14,000[/TD]
[TD="align: right"]74,000[/TD]
[/TR]
[TR]
[TD="align: right"]56,000[/TD]
[TD="align: right"]21,000[/TD]
[TD="align: right"]77,000[/TD]
[/TR]
[TR]
[TD="align: right"]52,000[/TD]
[TD="align: right"]28,000[/TD]
[TD="align: right"]80,000[/TD]
[/TR]
[TR]
[TD="align: right"]48,000[/TD]
[TD="align: right"]35,000[/TD]
[TD="align: right"]83,000[/TD]
[/TR]
[TR]
[TD="align: right"]44,000[/TD]
[TD="align: right"]42,000[/TD]
[TD="align: right"]86,000[/TD]
[/TR]
[TR]
[TD="align: right"]40,000[/TD]
[TD="align: right"]49,000[/TD]
[TD="align: right"]89,000[/TD]
[/TR]
[TR]
[TD="align: right"]36,000[/TD]
[TD="align: right"]56,000[/TD]
[TD="align: right"]92,000[/TD]
[/TR]
[TR]
[TD="align: right"]32,000[/TD]
[TD="align: right"]63,000[/TD]
[TD="align: right"]95,000[/TD]
[/TR]
[TR]
[TD="align: right"]28,000[/TD]
[TD="align: right"]70,000[/TD]
[TD="align: right"]98,000[/TD]
[/TR]
[TR]
[TD="align: right"]24,000[/TD]
[TD="align: right"]77,000[/TD]
[TD="align: right"]101,000[/TD]
[/TR]
[TR]
[TD="align: right"]20,000[/TD]
[TD="align: right"]84,000[/TD]
[TD="align: right"]104,000[/TD]
[/TR]
[TR]
[TD="align: right"]16,000[/TD]
[TD="align: right"]91,000[/TD]
[TD="align: right"]107,000[/TD]
[/TR]
[TR]
[TD="align: right"]12,000[/TD]
[TD="align: right"]98,000[/TD]
[TD="align: right"]110,000[/TD]
[/TR]
[TR]
[TD="align: right"]8,000[/TD]
[TD="align: right"]105,000[/TD]
[TD="align: right"]113,000[/TD]
[/TR]
[TR]
[TD="align: right"]4,000[/TD]
[TD="align: right"]112,000[/TD]
[TD="align: right"]116,000[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]119,000[/TD]
[TD="align: right"]119,000[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 276"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]PU[/TD]
[TD]DEL[/TD]
[TD]TOTAL[/TD]
[/TR]
[TR]
[TD="align: right"]68,000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]68,000[/TD]
[/TR]
[TR]
[TD="align: right"]64,000[/TD]
[TD="align: right"]7,000[/TD]
[TD="align: right"]71,000[/TD]
[/TR]
[TR]
[TD="align: right"]60,000[/TD]
[TD="align: right"]14,000[/TD]
[TD="align: right"]74,000[/TD]
[/TR]
[TR]
[TD="align: right"]56,000[/TD]
[TD="align: right"]21,000[/TD]
[TD="align: right"]77,000[/TD]
[/TR]
[TR]
[TD="align: right"]52,000[/TD]
[TD="align: right"]28,000[/TD]
[TD="align: right"]80,000[/TD]
[/TR]
[TR]
[TD="align: right"]48,000[/TD]
[TD="align: right"]35,000[/TD]
[TD="align: right"]83,000[/TD]
[/TR]
[TR]
[TD="align: right"]44,000[/TD]
[TD="align: right"]42,000[/TD]
[TD="align: right"]86,000[/TD]
[/TR]
[TR]
[TD="align: right"]40,000[/TD]
[TD="align: right"]49,000[/TD]
[TD="align: right"]89,000[/TD]
[/TR]
[TR]
[TD="align: right"]36,000[/TD]
[TD="align: right"]56,000[/TD]
[TD="align: right"]92,000[/TD]
[/TR]
[TR]
[TD="align: right"]32,000[/TD]
[TD="align: right"]63,000[/TD]
[TD="align: right"]95,000[/TD]
[/TR]
[TR]
[TD="align: right"]28,000[/TD]
[TD="align: right"]70,000[/TD]
[TD="align: right"]98,000[/TD]
[/TR]
[TR]
[TD="align: right"]24,000[/TD]
[TD="align: right"]77,000[/TD]
[TD="align: right"]101,000[/TD]
[/TR]
[TR]
[TD="align: right"]20,000[/TD]
[TD="align: right"]84,000[/TD]
[TD="align: right"]104,000[/TD]
[/TR]
[TR]
[TD="align: right"]16,000[/TD]
[TD="align: right"]91,000[/TD]
[TD="align: right"]107,000[/TD]
[/TR]
[TR]
[TD="align: right"]12,000[/TD]
[TD="align: right"]98,000[/TD]
[TD="align: right"]110,000[/TD]
[/TR]
[TR]
[TD="align: right"]8,000[/TD]
[TD="align: right"]105,000[/TD]
[TD="align: right"]113,000[/TD]
[/TR]
[TR]
[TD="align: right"]4,000[/TD]
[TD="align: right"]112,000[/TD]
[TD="align: right"]116,000[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]119,000[/TD]
[TD="align: right"]119,000[/TD]
[/TR]
</tbody>[/TABLE]