Morning,
I'm a bit of a novice with excel, self taught so far. I have attached a small extract from a spreadsheet that I am developing that may help to illustrate my problem.
I want to use the sheet to check customer demand (along with required delivery date) and compare that to a cell containing our current stock level for that product. I would like to use conditional formatting to show whether or not we have enough parts in stock to meet demand. It would be nice if the formula also had a buffer to highlight that we may be able to meet demand but that we would be cutting it close. For example, if we have 32 parts in stock and the customer demand was 30.
Thanks in advance for any help
Dan
Bookmarks