Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
Is this task possible to perform in Excel 2003?
I would like to have a quanity of material set point (example. 50) where I can deduct from this number daily for items used. When the deducted number reaches a set point of a lower number (example. 25) in the cell, Excel will notify me by either a flashing cell, color flash/change or astrick flash or some type of notification. My plans are to have a Description of the material starting in Column "B", Cost of item in Column "C", On hand quanity in Column "D", Additional information in Column in Column "E" and the daily deduction entered in Column "A". When the line item in Column "A" cell would reach a selected number, there would be a notification to me of time to reorder the item. Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
Excel does not support flashing text, however, you can have the cell change
color by using conditional formatting on the Format menu. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rick" wrote: Is this task possible to perform in Excel 2003? I would like to have a quanity of material set point (example. 50) where I can deduct from this number daily for items used. When the deducted number reaches a set point of a lower number (example. 25) in the cell, Excel will notify me by either a flashing cell, color flash/change or astrick flash or some type of notification. My plans are to have a Description of the material starting in Column "B", Cost of item in Column "C", On hand quanity in Column "D", Additional information in Column in Column "E" and the daily deduction entered in Column "A". When the line item in Column "A" cell would reach a selected number, there would be a notification to me of time to reorder the item. Thank you for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
Hello Shane,
I see the conditional formating tab in Excel but I am not sure how to set up the formula correctly. Looks like for my planned use it may be something like this: (Condition 1), Cell value is, less than or equal to A1:=A1-D1 Not sure ???? (Where the formula is A1=25-50) I need the predetermined set value of 25 to turn "red" when a quanity is entered each day for the material item being used. Can you help me by providing the formula which I would need to use? Thanks, Rick "Shane Devenshire" wrote: Excel does not support flashing text, however, you can have the cell change color by using conditional formatting on the Format menu. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Rick" wrote: Is this task possible to perform in Excel 2003? I would like to have a quanity of material set point (example. 50) where I can deduct from this number daily for items used. When the deducted number reaches a set point of a lower number (example. 25) in the cell, Excel will notify me by either a flashing cell, color flash/change or astrick flash or some type of notification. My plans are to have a Description of the material starting in Column "B", Cost of item in Column "C", On hand quanity in Column "D", Additional information in Column in Column "E" and the daily deduction entered in Column "A". When the line item in Column "A" cell would reach a selected number, there would be a notification to me of time to reorder the item. Thank you for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
I need the predetermined set value of 25 to turn "red" when a quantity is
entered each day for the material item being used. Try these steps Select say, A2:A10 (A2 active), then apply CF using Formula Is: =AND($D2<"",$D2-$A2<=25) Format to taste ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
Thank you Max,
Excellent job, works perfectly as you recommended... Rick "Max" wrote: I need the predetermined set value of 25 to turn "red" when a quantity is entered each day for the material item being used. Try these steps Select say, A2:A10 (A2 active), then apply CF using Formula Is: =AND($D2<"",$D2-$A2<=25) Format to taste ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
Good to hear that, Rick. You're welcome
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Rick" wrote in message ... Thank you Max, Excellent job, works perfectly as you recommended... |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Notice in Excel of a reached set point setting.
Please follow following steps:-
1.Click on cell A 2.Click FormatConditional Formatting from the toolbar 3.In the dialog box select Cell Value Is from the left combo box 4.Select less than from middle combo box 5.Click on the text box to the right 6. Now give the minimum value 7.Then select color by clicking on format button. 8. Click ok You are done€¦€¦€¦ Chris ------ Convert your Excel spreadsheet into online calculator. http://www.spreadsheetconverter.com -- Chris ------ Convert your Excel spreadsheet into online calculator. http://www.spreadsheetconverter.com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200901/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting a formula = to no point in a graph | Excel Discussion (Misc queries) | |||
Disable the Excel Security notice pop-up? | Excel Discussion (Misc queries) | |||
Anyone notice excel search within cell limited to first 1024 chars | Excel Discussion (Misc queries) | |||
setting defaults for data point size, color, shadow, etc. | Charts and Charting in Excel | |||
setting a floating decimel point | New Users to Excel |