a1 a2 a3 a4 a5 a6 a7 a10
100 113 145 7 65 1007 3 245

From the cells and numbers above, I need to get a formula or conditional
format setting that will show me which cell A10's number will no longer be
enough. Cell A10 is the number of items I have, the other cells are the
number of items I need to ship each day. I need something to show me at which
cell I don't have enough items on hand. The answer for the data above would
be Cell A3. At cell A3 there is no longer enough in cell A10 to fill that
order. In....say cell a11 I need it to show me either which cell number or
date or something of when I will be out of items.


Thanks,