IF Statement for inventory control

  • Thread starter Thread starter Laura Howard
  • Start date Start date
L

Laura Howard

My son keeps track of inventory in a spreadsheet. He wants some sort of
alert if the number goes below 5 by either changing the number to "red" or
flash. Is there any IF statement that can do this??? Thank you for your
help.
 
Laura

Select the cell and Format>Conditional Formatting.

Condition1: cell value is: less than 5

Format to a red pattern and OK.

Note: you can have 3 conditions formatted if you wish.

Flashing/Blinking cells are an abomination and can only be done through
programming which takes up much resources to keep the cell flashing.

Gord Dibben Excel MVP
 
Back
Top