Sep 12 2020 05:13 PM
Morning World
Im trying to set up an excel sheet to determine when productions are to happen and using colour to identify when stock levels reach a low point that a new production is required. Ideally I want to use 3 month or 6 months average sales to determine the colour change, Im sure this can be done just beyond my ability and knowledge.
So I have 1 row for actual sales for months past, then forecast sales for the months after (these are just current averages at the moment), then the next row is productions that can be programmed and finally the stock on hand as a calculation of previous months stock, less sales plus productions.
I would really appreciate any help on this. Ideally want to get a good soft colour change to see where stock levels are within 3 months of running out based on average sales, if possible.
Sep 14 2020 02:08 AM
Nikolino
I know I don't know anything (Socrates)
Sep 14 2020 02:12 AM
Enclosed the example in your file, as well as instructions for conditional formatting.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.