I have a workbook that uses inventory and sales by fiscal week to help identify sales that we missed due to stockouts. Unfortunately, when I have multiple weeks in a row with both no inventory and sales during peak season, the formula is thrown off and I need to dive in manually. How can I conditionally format the sheet that identifies stockout losses to shade cells in as red when there is a zero in both inventory and sales during a given week? I have sheets that show sellable inventory at week's end, sales at week's end, and the potential sales loss to stockouts. I'm using 2003 by the way.
Thanks everyone.
Bookmarks