IF Statement for inventory control

[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.

 

[Gord Dibben]

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