Hi Guys,
Sorry about the confusion and poor explanation.
The formulas as suggested by Ossie or Dallman don't do what I am trying to do:
Columns A through E contain 5 days/week production levels, column F contain
the customer order. What I am trying to do is to examine production against
orders and higlight or shade (same thing) what will be used from production.
To put this into a numeric example:
A B C D E F
5 3 3 4 2 10

if the order is 10, then what will be used from production is 5 + 3 +3 (Then
A, B & C should be shaded or highlited). Since 5 + 3 + 3 = 11 and 11 is
than 10, cell C should be higlighted although it will only be partially used.
In another scenario, if F = 8, A and B should only be shaded
or if F = 15, then A, B, C & D should be shaded.

Trying to generalize what I just explained using an if statement:
If F1 0, shade A1 and continue evaluation, else stop
if F1A1+0, shade B1 and continue evaluation, else stop
if F1A1+B1, shade C1 and continue evaluation, else stop
if F1 A1+B1+C1, shade D1 and continue evaluation else stop
if F1 A1+B1+C1+D1, shade E1 else stop

The question in this case is how to formulate this programatically or using
conditional formating.

Sorry again about the confusion and I hope that this was a clear enough
explanation.
Thanks a lot for your help

Karim