| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: How do I format a cell if value < 12 then show "LOW STOCK"
Trying to format cells with conditions to show values; LOW, VERY LOW, etc.
Thanks. CNS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL: How do I format a cell if value < 12 then show "LOW STOCK"
You can do this with a formula in another cell but not with formatting
IF(A1<2,"Very Low","OK") or IF(A1<2,"Very Low",IF(A1<10,"Low","OK") and so on OR =HLOOKUP(A1,{0,5,10,20;"very low","low","medium","large"},2,TRUE) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "CNSmith" wrote in message ... Trying to format cells with conditions to show values; LOW, VERY LOW, etc. Thanks. CNS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| EXCEL: How do I format a cell if value < 12 then show "LOW STOCK" | Excel Worksheet Functions | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
| Format Cell to show "-1" in subscript | Excel Discussion (Misc queries) | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
Linear Mode
