ersanr
New Member
hi masters, can you enlighten me.. it is for warehousing.
the main idea is highlighting the cell to reminder if the stock is bellow buffer stock (by average usage)
note :
• cell E3 - K3 is where i input daily usage of sugar.
the conditional formatting formula apply if:
1. when the cell is blank (ie:G3-K3)
2. when the livestock (B3) is bellow buffer stock (M3) after minus average usage (N3)
ie: the highlighted G3 is for reminder that the livestock is bellow buffer stock (65-17,5=47,5)
thankyou
the main idea is highlighting the cell to reminder if the stock is bellow buffer stock (by average usage)
note :
• cell E3 - K3 is where i input daily usage of sugar.
the conditional formatting formula apply if:
1. when the cell is blank (ie:G3-K3)
2. when the livestock (B3) is bellow buffer stock (M3) after minus average usage (N3)
ie: the highlighted G3 is for reminder that the livestock is bellow buffer stock (65-17,5=47,5)
thankyou