Conditional Format in pivot table ??

I'm using a pivot table to display part numbers in rows, due dates in columns, to show quantities due for each item on each day. I also have an inventory column for each part and want to highlight the first order where I encounter a shortage. For example row 31; part number is 3040677, due dates as follows, 1/19 - 56, 1/24 - 50, 1/25 - 32, 1/26 - 60, and I have 156 available. So I want excel to highlight cell AJ31 which is the 1/26 order for 60 because I will have a negative quantity of 42 on that day and all other orders after that day. I attached my sheet so you have the raw data to work with.

Originally Posted by MarvinP

Hi Oly Steel Man,

I have a little different answer for your problem.
1. Pivot Tables can show Running Totals (by Due Date). Do this first then
2. In Column BQ5 do an Index-Match fomula to show the last date before running out

Please Login or Register  to view this content.

Copy the above formula down.

I found conditional formatting inside Pivot Tables a problem but the above does what you may need.

I tried this formula but its not giving me my shortage date, I believe it's returning the latest order date. My example showed it should be 1/26, but its returning a date of 2/11.

The other solution you offered works but there is so much information to look at with that I was hoping to be able to see my order quantities still. But if that's not possible I suppose I could make this work. Any other suggestion would be appreciated but a big thank you for the help you've provided.