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

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