Inventory Level

[Closed]
Report
-
 Armin -
Hello,

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 reply

Posts
60
Registration date
Monday December 21, 2009
Status
Member
Last seen
December 25, 2009
10
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 .