Inventory Level

Armin - Dec 25, 2009 at 12:11 AM
 Armin - Dec 25, 2009 at 03:30 AM

I have 12 month inventory quantity in cell A1 to L1 and their SUM in M1.

I want in excell when my inventory quantity (M1) is lower than sum of A1+B1+C1 then show cell A1 , B1 ,C1 in green and D1,E1,F1, ..... but M1 in Red.

1 response

lfefil Posts 60 Registration date Monday December 21, 2009 Status Member Last seen December 25, 2009 10
Dec 25, 2009 at 02:10 AM
use condtional formating
Dear lfefil

Thank you for your reply but conditional formating use for each single cells to be compared together and when I want to compare a single cell N1 ( as SUM of 12 month) with progressive A1 ,B1 and C1 (month after month) total value , I do not know how .

this way I see each month inventory quantity and progress .