HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL?

  • Thread starter Thread starter PENNY
  • Start date Start date
P

PENNY

I WANT TO ENTER A FORMULA WHERE IT WILL FLAG/HIGHLIGHT OR SIMILAR WHEN A
LEVEL REACHES A REORDER POINT - HOW CAN I DO THIS. I.E. WHEN THE GAS OIL TANK
REACHES 3,000 LITRES, I NEED TO RE-ORDER - CAN I USE A FORMULA SO IT
HIGHLIGHTS THIS FOR ME? THANKS!
 
Conditional Formatting:

Cell Value | greater than or equal to | 3000

Format any color you like
 
Back
Top