Thread: EXCEL: How do I format a cell if value < 12 then show "LOW STOCK"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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 With QuoteReply With Quote