## Daily Capacity Conditional Formatting

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

(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

## Solutions to the Problem Daily Capacity Conditional Formatting

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)

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

## Another Safe way to Repair the Problem: Daily Capacity Conditional Formatting:

### How to Fix Daily Capacity Conditional Formatting with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.