Hi,
I am trying to make an inventory sheet that will automatically hilight low
levels:
Each product has values in columns A through E (representing 5 days). Cell F
contain the requested quantities.
What I am trying to do is to change background colour of the cells that will
sum the requested quantities.
For example:
A B C D E F
5 3 3 4 2 10

A, B and C should be hilighted (5+3+3 = 11, 1110)
Is there any way I can do this with conditional formating? or in another way?
I have about 500 products (rows) that I need to do the same function to.

Thanks,