| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
