Daily Capacity Conditional Formatting

Question

I'm trying to figure out a way to do a conditional format of a cells in column A which highlights if a job capacity of a day exceeds a certain warehouse.  In column A i have the name of the Warehouses. In column B i have the date. In Column C i have the quantity of each job.  There are multiple Jobs per day so I need to figure out a total quantity for all the jobs 

So if 'ABC' goes over 500 on any particular day then highlight ABC for that day, if 'TTI' goes over 600 then highlight TTI for that day. If 'AMG' goes over 1100 on a particular day then highlight AMG. In this case AMG would be highlighted since on 06/15/2013 it adds up to 1300.

(Warehouse) (Date) (QTY Job)

Column A Column B Column C

ABC 06/15/2013 300

TTI 06/16/2013 500

AMG 06/15/2013 600

TTI 06/17/2013 300

AMG 06/15/2013 700

ABC 06/18/2013 800

Answer 1

First we need a table with the warehouse capacities:

ABC    500

AMG  1100

TTI      600

Name this table Capacity

Select the cells you want conditionally formatted, with the active cell on row 2.

Create the conditional format using formula

=SUMIFS($C:$C,$A:$A,$A2,$B:$B,$B2)>VLOOKUP($A2,Capacity,2,FALSE)

Answer 2

That's great Bill, as usual