help needed with formula or macro or both !!
 

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

help needed with formula or macro or both !!
 

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

help needed with formula or macro or both !!
 

Paul that's excellent, I made it work ok but just cant seem to make the
conditional cell format thing work, it would be great to turn the cell red
when the leave reaches re-order


"paul" wrote in message
...
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

help needed with formula or macro or both !!
 

richard:

highlight the cells in the row you would like to turn red.
click format/conditional formatting

condtion1:
cell value then choose less than or equal to and then enter
the number 10 in the formula box

click format

choose font, you might want to make it white
choose border if you want a border around it
choose patterns and click the red square

click ok twice


--


Gary


"richard knight" wrote in message
...
Paul that's excellent, I made it work ok but just cant seem to make the
conditional cell format thing work, it would be great to turn the cell red
when the leave reaches re-order


"paul" wrote in message
...
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