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

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!
 
T

Teethless mama

Conditional Formatting:

Cell Value | greater than or equal to | 3000

Format any color you like
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Multi Level list using Header Style 1
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Having a cell flag me 1
Inventory levels in stock control database 5
Cell referencing 1
Message Box 5
How can I order the note flag summary? 2
Notice in Excel of a reached set point setting. 6

Top