sure in cell n1 you could have =if(m1<=10,"reorder!","") or in m1 =if(your
formula for stock on hand <= 10,your formula for stock on hand &"
reorder!",your formula for stock on hand) and copy down,or you could have a
conditional format so that if cell value is less than 10 you have your text
formatted red or the cell colured or patterned in some way.Check out
coditional formatting in help
paul
remove nospam for email addy!



"richard knight" wrote:

I'm not sure if this is possible but am whiling to pay for help if anyone
can make this work.....

I want a macro or formula in excel that does the following,,,,

Look at the content of a cell (that being a number value of say 25) when
this figure reaches a minimum say 10 a warning is highlighted or email sent
with the rows content

it would be every cell in a column say column M, from 0 to 220

I'm trying to use this to control some stock levels here and notify me
either via email or visually when I hit my re-order level