Conditional Formatting

[TaylorLeigh]

I want the message "Inventory is below minimum" when a calculated field falls
below a certain number. Is it possible to have this message appear in the
cell next to the number and stay there until the number is changed to be
greater than the minimum?

 

[Teethless mama]

=IF(A1<10,"Inventory is below minimum","")

Adjust to suit

 

[TaylorLeigh]

That works. Can I have two if/then statements. One below 15 and one below 10?

Thanks,