ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formatting (https://www.excelbanter.com/excel-worksheet-functions/198107-conditional-formatting.html)

TaylorLeigh

Conditional Formatting

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

Conditional Formatting

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

Adjust to suit

"TaylorLeigh" wrote:

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?

TaylorLeigh

Conditional Formatting

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

Thanks,

"Teethless mama" wrote:

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

Adjust to suit

"TaylorLeigh" wrote:

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?

All times are GMT +1. The time now is 10:37 PM.