EXCEL: How do I format a cell if value < 12 then show "LOW STOCK"

C

CNSmith

Trying to format cells with conditions to show values; LOW, VERY LOW, etc.

Thanks.

CNS
 
B

Bernard Liengme

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
 
Top