Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and coloring cells, formula or macro help needed | Excel Discussion (Misc queries) | |||
Help needed with a formula or macro | Excel Discussion (Misc queries) | |||
Macro or Formula needed | Excel Discussion (Misc queries) | |||
Formula or Macro needed? | Excel Discussion (Misc queries) | |||
Macro or Formula needed to search data in cells | Excel Programming |