Excel - Colour Formatting Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1661018%22%20slang%3D%22en-US%22%3EExcel%20-%20Colour%20Formatting%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661018%22%20slang%3D%22en-US%22%3E%3CP%3EMorning%20World%3C%2FP%3E%3CP%3EIm%20trying%20to%20set%20up%20an%20excel%20sheet%20to%20determine%20when%20productions%20are%20to%20happen%20and%20using%20colour%20to%20identify%20when%20stock%20levels%20reach%20a%20low%20point%20that%20a%20new%20production%20is%20required.%20Ideally%20I%20want%20to%20use%203%20month%20or%206%20months%20average%20sales%20to%20determine%20the%20colour%20change%2C%20Im%20sure%20this%20can%20be%20done%20just%20beyond%20my%20ability%20and%20knowledge.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20have%201%20row%20for%20actual%20sales%20for%20months%20past%2C%20then%20forecast%20sales%20for%20the%20months%20after%20(these%20are%20just%20current%20averages%20at%20the%20moment)%2C%20then%20the%20next%20row%20is%20productions%20that%20can%20be%20programmed%20and%20finally%20the%20stock%20on%20hand%20as%20a%20calculation%20of%20previous%20months%20stock%2C%20less%20sales%20plus%20productions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20any%20help%20on%20this.%20Ideally%20want%20to%20get%20a%20good%20soft%20colour%20change%20to%20see%20where%20stock%20levels%20are%20within%203%20months%20of%20running%20out%20based%20on%20average%20sales%2C%20if%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661018%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1663476%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20-%20Colour%20Formatting%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663476%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791568%22%20target%3D%22_blank%22%3E%40falconfiasco%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIt%20would%20be%20helpful%20if%20you%20included%20a%20file%20(with%20no%20sensitive%20data).%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eso%20you%20could%20get%20help%20faster%20and%20some%20in%20this%20community%20could%20offer%20you%20the%20best%20possible%20solution.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3ESo%20you%20could%20see%20the%20macro%2C%20whether%20the%20error%20can%20be%20found%20there%2C%20for%20example.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

 

 

 

2 Replies

@falconfiasco 

It would be helpful if you included a file (with no sensitive data). so you could get help faster and some in this community could offer you the best possible solution.
So you could also see the macro, whether the error can be found there, for example.
 
 

Nikolino

I know I don't know anything (Socrates)

@falconfiasco 

Enclosed the example in your file, as well as instructions for conditional formatting.

Use conditional formatting to highlight information

https://support.microsoft.com/en-gb/office/use-conditional-formatting-to-highlight-information-fed60...

 

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.